linked server on Oracle and Oracle query questions

• Vladimir Sim

  Ten Centuries

  Points: 1310

  More actions

  April 25, 2006 at 8:31 am

  #93961

  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

• Scorpion_66

  SSCertifiable

  Points: 7891

  More actions

  April 25, 2006 at 9:24 am

  #634072

  It looks like the schema which the table belongs to

• Hrudhay

  SSChasing Mays

  Points: 638

  More actions

  April 26, 2006 at 3:37 am

  #634233

  I assumed that you're trying to execute the Select statement in query analyzer.

  If you want to run a select statement to Oracle table then the syntax is

  Select * from Openquery(Oracle Data source Name,'Select * from table1')

• Linda Johanning

  SSCertifiable

  Points: 6727

  More actions

  April 26, 2006 at 8:35 am

  #634318

  You can also try using the 4-part naming convention.  Make sure the Oracle schema and object names are in caps.

  "select * from LinkedServerName..ORACLESCHEMA.TABLENAME"