Re: Tables from two databases

From: Michael R. Young <Michael.Young_at_irp.gatech.edu>
Date: Tue, 16 Nov 1999 11:51:44 -0500
Message-ID: <80s1ui$rvm$1@news-int.gatech.edu>

create a database link for db1 (unless local) create a database link for db2 (unless local)

create view v1 as ..... select a1.name + a2.name from a1_at_db1, a2_at_db2

Mr. Chow Wing Siu <wschow_at_Comp.HKBU.Edu.HK> wrote in message news:80rub9$ms$1_at_power25t.hkbu.edu.hk...
> Hi,
>
> I have two tables (with same definition and structure but
> different contents) from two separate databases.
>
> I want to create a view to select, update, delete from
> two tables. Any update will do in according to some
> constraints to the database (db1 or db2). How to do it?
>
> EG, table a1 (name varchar2(2)) at db1 and
> a2 (name varchar2(2)) at db2
>
> view v1 = a1+a2
>
> Thanks for help.
>
> --
> Johnson Chow
Received on Tue Nov 16 1999 - 10:51:44 CST