Joins across two databases

[DonWhit]

Is it possible to create a join across 2 different Oracle databases?

 

[Marco Kalter]

Yes, but you'll have to declare one of the database as the 'primary database' (where your users log on), and create a database link in the primary database to the secondary database. You can subsequently access tables from both databases in your select statements.