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
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.