OraFAQ Forum: SQL & PL/SQL » cross database views

Home » SQL & PL/SQL » SQL & PL/SQL » cross database views

Thu, 22 August 2002 08:57

John Bonin
Messages: 3
Registered: August 2002

Junior Member

Does anyone know how to implement a view in Oracle 8i
that joins tables across multiple databases/instances?

Thanks!

John

Thu, 22 August 2002 09:07

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

You would use database links to the other instances and reference those within the view - just as you would in a regular query:

create or replace view view_name
as
select t1.id, t2.desc
  from local_table t1, remote_table@somedblink t2
 where t2.id = t1.id;

Previous Topic:	Query about exporting database
Next Topic:	Re: optimizing sql statement

Goto Forum:

]

Current Time: Thu Apr 25 10:40:03 CDT 2024