The OLE DB Provider MSDAORA For Linked Server .... Does Not Contain The Table COUNTRY. The Table Either Does Not Exist Or The Current User Does Not Have Permissions On That Table.

I am using SQL Server 2005 and trying to create a linked server on Oracle 10. I used the commands below:

EXEC sp_addlinkedserver

@server = 'test1',

@srvproduct = 'Oracle',

@provider = 'MSDAORA',

@datasrc = 'testsource'

exec sp_addlinkedsrvlogin

@rmtsrvname = 'test1',

@useself = 'false',

@rmtuser='sp',

@rmtpassword='sp'

 

When I execute

select * from test1...COUNTRY

I get the error. "The OLE DB provider "MSDAORA" for linked server "...." does not contain the table "COUNTRY". The table either does not exist or the current user does not have permissions on that table."

The 'sp' user I am connecting is the owner of the table. What could be the problem ?

Thanks a lot.