Table join from different servers

#1

Is it possible to obtain data from two different databased, each being on a
different server. How would the query be written?

example:

TABLE1 on SERVER1 db1name/db1pass@instance1
TABLE2 on SERVER2 db2name/db2pass@instance2

TABLE1
--------------------
column_a1
column_b1
column_c1

TABLE2
---------------------
column_a2
column_b2
column_c2

TABLE JOIN:
column_a1 column_a2 column_b2 column_c1
----------- ------------ ------------ -------------
apple fruit red tree
orange fruit orange tree
grape fruit purple vine
pumpkin vegetable orange vine

#2

JustAQTCub wrote:

Quote:

Is it possible to obtain data from two different databased, each being on a
different server. How would the query be written?

example:

TABLE1 on SERVER1 db1name/db1pass@instance1
TABLE2 on SERVER2 db2name/db2pass@instance2

TABLE1
--------------------
column_a1
column_b1
column_c1

TABLE2
---------------------
column_a2
column_b2
column_c2

TABLE JOIN:
column_a1 column_a2 column_b2 column_c1
----------- ------------ ------------ -------------
apple fruit red tree
orange fruit orange tree
grape fruit purple vine
pumpkin vegetable orange vine

why not establish a database link then just refernce the othertable@your

link?

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Table join from different servers

comp.databases.oracle comp.databases.oracle

Table join from different servers - 02-24-2007 , 09:08 PM

Re: Table join from different servers - 05-20-2007 , 08:06 PM