Re: one connexion for two database ORACLE

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 18 Jun 2001 23:23:21 +0200
Message-ID: <i8ssitctvcc5rkktu98o25da70igo5ha97@4ax.com>

On Mon, 18 Jun 2001 21:34:56 +0200, "Frederic GERNEZ" <Frederic.GERNEZ_at_wanadoo.fr> wrote:

>hello,
>
> I have two database (2 datamart dm1 & dm2) and i would like ,with one
>SQLPLUS connexion, to see the tables from dm1 and dm2.
>
>thanks.
>

The obvious solution to that would be create a database link between dm1 and dm2. You can't have multiple connections from sqlplus nor any other Oracle tool.

Hth,

Sybrand Bakker, Oracle DBA Received on Mon Jun 18 2001 - 16:23:21 CDT