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 |
|
jszulc
Yak Posting Veteran
66 Posts |
 Posted - 2011-03-25 : 07:09:09
|
| Hello there, I configured a linked server in SQL 2008 to Oracle server. ( I have only ready access to Oracle db) using Oracle OLEdb. I am able to pass OPEQUERY requests to it and the results are coming very fast. All tables in Oracle are approx 50 000 rows. I would like to get advise on how to handle join queries on Oracle tables. An example would be great showing how to perform LEFT JOIN on Oracle through openquery.If this is not the best way to do it, can someone please post a statemnet how to dump the contents of the entire Oracle table to SQL 2008? What method is the best?I may just run a job nightly and dump these tables locally to SQL 2008 and query them locally. I hate working on stake data though, even if it was dumped last night. |
|
|
|
|
|
SQL2008 and Oracle 10g issue