Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Linked server to Oracle-Openquery Expand / Collapse
Author
Message
Posted Wednesday, June 13, 2012 12:01 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 6:34 PM
Points: 351, Visits: 1,653
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,
Post #1315365
Posted Wednesday, June 13, 2012 1:06 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Yesterday @ 6:34 PM
Points: 351, Visits: 1,653
PLease help on this issue..
Post #1315425
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse