I need to access object from Oracle 9i. I've installed O9i client on sql server and create linked server to O9i db. but when executing
exec sp_tables_ex N'SUN920' ---> list of all table appear
and when selecting from a prticular table -- got below msg
Msg 7314, Level 16, State 1, Line 2
The OLE DB provider "OraOLEDB.Oracle" for linked server "sun920" does not contain the table ""shm"."x"". The table either does not exist or the current user does not have permissions on that table.