AnotherUser_at_abc.com.au said...
> It is not that easy as I have Error by doing
>
> SELECT A.*, B.*
> FROM Table1_at_A A,
> Table2_at_B B
>
> ORA-02019: connection description for remote database not found
>
>
> "Ana C. Dent" <anacedent_at_hotmail.com> wrote in message
> news:Xns9334AFF3EA27ASunnySD_at_68.6.19.6...
> > "AnotherUser" <AnotherUser_at_abc.com.au> wrote in
> news:b43hai$d83$1_at_mws-stat-
> > syd.cdn.telstra.com.au:
> >
> > > Hi Everyone,
> > >
> > > I have on my Server different Databases A, B, C, D etc ...which require
> a
> > > different Loggons and passwords.
> > >
> > > How can I access all these in one SQL ??
> >
> > Easily.
> >
> > What is "in one SQL"?
> >
> >
> > SELECT A.COL1, B.COL2, C.COL3, D.COL4
> > FROM TABLE_A_at_A A,
> > TABLE_B_at_B B,
> > TABLE_C_at_C C,
> > TABLE_D_at_D D;
>
Go to http://asktom.oracle.com and search for "dblink" (without quotes).
--
/Karsten
DBA > retired > DBA
Received on Wed Mar 05 2003 - 10:24:21 CST
