Linked Server for Oracle

Hi

I need to migrate data from an Oracle database to a SQL Server 2005 database (Dev Edition),

I created a linked server object using the following : -

exec sp_addlinkedserver 'JAVAX', 'ORACLE','OraOLEDB.Oracle', 'JAVAX.world'

exec sp_addlinkedsrvlogin 'JAVAX','false','XXX','XXX','YYY'

GO

XXX login exists on sql server as well as Oracle.

However I am unable to see any of the tables under the linked server and when I try to access the query like below it returns an error "Invalid object name 'JAVA109.sfmfg.SFCORE_USER'."

Select * from JAVAX.sfmfg.SFCORE_USER

Insert a dot after "JAVAX":

Select * from JAVAX..sfmfg.SFCORE_USER

I'm assuming the server alias is "JAVAX", the schema owner is "sfmfg" and the table or view is "SFCORE_USER".