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?.