Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Access to different Oracle (8i) Databases in one SQL
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;
Received on Tue Mar 04 2003 - 20:55:32 CST