Page 1 of 1

join 2 tables from 2 oracle databases

Posted: Fri 22 May 2009 14:34
by jlcostinha
i have 2 Oracle servers (one 11g and a 9i), in my application i have 2 orasession to each database and i can perform queries on each database alone using the correct session...

now, i need to perform a query that will join 2 tables one from each database, is it possible? how can i do it?

thanks.

Jorge

Posted: Sat 23 May 2009 08:49
by jfudickar
The only way is to join the tables via database link on one of the databases and then use session which is connected to this database.

Kind regards
Jens