Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: one connexion for two database ORACLE
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