Re: Using Multiple DBs in Oracle8 PL/SQL

From: Mike Rose <mmrose_at_home.com>
Date: Sun, 14 Mar 1999 23:22:34 GMT
Message-ID: <_wXG2.8445$573.3520@news.rdc1.md.home.com>

Research how to create an Oracle Database Link. You will need a Database Link defined in the database your PL/SQL is running on so that you can connect to Tables/Views in the 'other' database.

In your PL/SQL simply use the Database Link when you refer to objects.

Example: [Schema.]Table_at_DatabaseLink or [Schema.]View_at_DatabaseLink

Mike Rose

Adam Sorati wrote in message <36EC3B1E.3F5675F4_at_sgen.com.au>...
>I am using Oracle8 and have been given the task of writing an archive
>program,
>which is required to move data out to another DB.
>
>My plan is the write a PL/SQL function to do this.
>My question is can a PL/SQL function refference 2 Oracle8 DBs and how is
>it done.
>
>Any help or comments on the would be appreciated.
>
>--
>Adam Sorati
>adams_at_sgen.com.au
>
>SoftGen Australia
>
>
Received on Sun Mar 14 1999 - 17:22:34 CST