Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: one connexion for two database ORACLE

Re: one connexion for two database ORACLE

From: Frederic GERNEZ <Frederic.GERNEZ_at_wanadoo.fr>
Date: Tue, 19 Jun 2001 20:32:55 +0200
Message-ID: <9go5mp$jlo$1@wanadoo.fr>

hello,

    it's not possible because the connection is for Buisness Object and     he kown only the tables of one connection.

    i does'nt specify the table name because it's a drop down.

Thanks

Daniel A. Morgan <Daniel.Morgan_at_attws.com> a écrit dans le message : 3B2E64F1.87EB3AD3_at_attws.com...
> Frederic GERNEZ 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.
>
> Build a database link between the two instances.
>
> Log onto the one hosting the link and reference the tables in the other.
>
> Daniel A. Morgan
>
Received on Tue Jun 19 2001 - 13:32:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US