Linkedserver to Oracle database

• Dhruva_51

  SSChampion

  Points: 10521

  More actions

  June 13, 2012 at 11:57 am

  #259761

  Hi all,

  Env: Oracle 11R2 64 bit, sql server 2008 R2 64 bit SP1

  I was able to setup the Linkedserver to Oracle server using ODBC connection and was tested successfully.

  But when i run the OPENQUERY statement i am not retreiving the total rows exists in oracle table.

  Query is returning only few rows out of all.

  Here is the sample query i am running-

  select * from openquery ([Oracle_ServerName],

  'select * from schemaname.testtable' )

  Does any one faced the same issue?.

  Thanks,

• ard5karthick

  SSCommitted

  Points: 1603

  More actions

  June 15, 2012 at 7:38 am

  #1501649

  Hi Muthyala,

  Try entering the Linked Server name before the Schema name.

  Select * From LINKEDSERVERNAME..SCHEMANAME.TABLENAME

  Thanks,

  Karthick.