Linked server and Oracle questions | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Linked server and Oracle questions


Hi, I have 02 issues with Oracle and linked server on SQL Server 2000. First, I have successfully setup 02 linked server to a Oracle Database and able to see all the tables and views. Second, I am given some query by the Oracle DBA like ‘SELECT * from tams.db01 where xxxx’ & ‘select * from dbo1.names where xxxx’, but from my linked server, I can’t seem to find the db01 tables or tams. Anyone who know what ‘tams’ and db01 mean in the query. Please advise. Thank you
That ‘tams’ and db01 may be related to the database on the Oracle. Referhttp://www.databasejournal.com/features/mssql/article.php/3290801 &http://www.sqlmag.com/Article/ArticleID/22264/22264.html for information on using ORacle and SQL in linked servers. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>