Re: interesting problem
From: Matthias Gresz <nospam_at_newsranger.com>
Date: Fri, 07 Sep 2001 07:19:21 GMT
Message-ID: <Zx_l7.7631$4z.32327_at_www.newsranger.com>
Date: Fri, 07 Sep 2001 07:19:21 GMT
Message-ID: <Zx_l7.7631$4z.32327_at_www.newsranger.com>
Hio Jerry,
you could create a (public) database link from db1 into db2.
CREATE DATABASE LINK mylink_to_ db2
CONNECT TO scott IDENTIFIED BY tiger
USING 'sales';
Where 'sales' is a connection descriptor pointing to db2 and is stored in db1's
tnsnames.ora.
Over this link you can access the data in db2 from db1. In db1 you may acces a specific table by
schema1.table1 and the corresponding table in db2 by schema1.table1_at_link_to_db2. More over you may create synonyms for the tables used in db2.
hth
Matthias Received on Fri Sep 07 2001 - 09:19:21 CEST