join 2 tables from 2 oracle databases

[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

[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