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.
| 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 1An 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+'"' |
 |
|
|
|
|
|
|
|
Linked server to ORACLE!!!Help requested.....