query across 3 Oracle DBs and MS-SQL

From: <sydneypuente_at_yahoo.com>
Date: Thu, 12 Mar 2009 04:00:43 -0700 (PDT)
Message-ID: <1b7c11d9-f6d6-41e1-8542-0cac44805789_at_h20g2000yqn.googlegroups.com>

Hello Guys,

I will shortly be tasked with running some complex queries across 3 X Oracle DBs and MS-SQL. Each of these db has millions of lines. I have run queries again a single Oracle DB with millions of lines with some success - that take several hours to complete. However I have little idea of what is best practice to query databases on different servers and a vendor other than Oracle in the mix too.

hints and tips and URLs gratefully received!!

Syd Received on Thu Mar 12 2009 - 06:00:43 CDT

Original text of this message