Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Linked server to ORACLE!!!Help requested.....

Author  Topic 

kgundava
Yak Posting Veteran

66 Posts

Posted - 2011-07-13 : 10:19:46
Hi All,
I am using the Linked server concept to do a data validation on two different databases in SQL server. I have created linked servers pointing to these two databases(attunity, Oracle).
I am running an except query to get the differences. For some reason oracle linked server is loosing it's connection when it is running a Except Query which i guess involves two large tables.
Is it due to some time out settings on SQL server Or oracle.If so please let me know where i have to look for....

Please see the error below.
OLE DB provider "OraOLEDB.Oracle" for linked server "QASSAPORACLE" returned message "ORA-03135: connection lost contact".
Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing the query "SELECT "Tbl1002"."MANDT" "Col1033","Tbl1002"."AWTYP" "Col1034","Tbl1002"."AWREF" "Col1035","Tbl1002"."AWORG" "Col1036","Tbl1002"."POSNR" "Col1037","Tbl1002"."CURTP" "Col1038","Tbl1002"."WAERS" "Col1039","Tbl1002"."WRBTR" "Col1040","Tbl1002"."KURSF" "Col1031" FROM "SAPR3"."ACCTCR" "Tbl1002"" for execution against OLE DB provider "OraOLEDB.Oracle" for linked server "QASSAPORACLE".
Thanks in advance...............

kgundava
Yak Posting Veteran

66 Posts

Posted - 2011-07-13 : 10:34:07
Addition Information for The Above Question:
I am using this query to do the validation:
select * from QASSAPORACLE..SAPR3."'+@TABLE_NAME+'" except select '* from QSPARCVFED..SAPR3."'+@TABLE_NAME+'"'
Go to Top of Page
   

- Advertisement -