Re: grab info from two databases

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 28 Aug 2001 09:36:39 +0200
Message-ID: <tomk4s5jt1ib2e@news.demon.nl>

"Andrew Phuong" <caop_at_infosci.com.au> wrote in message news:PEHi7.34$DG3.772_at_wa.nnrp.telstra.net...
> Hi All,
>
> I was wondering how you gurus would solve this?
>
> I have this problem where one process needs to be able to
> do SQL selects, update ..etc on two different databases.(e.g db1 and db2)
>
> I've been told that one process can only connect to 1 database at a time.
> In which case how can i grab information from two databases without having
> to
> disconnect from one to get to the other?
>
> Thanks 4 the help..
>
> Andrew P
>
>

Read up in your documentation on distributed databases and database links.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Tue Aug 28 2001 - 02:36:39 CDT