Re: Access to different Oracle (8i) Databases in one SQL

From: AnotherUser <AnotherUser_at_abc.com.au>
Date: Wed, 5 Mar 2003 13:55:32 +1100
Message-ID: <b43ouu$gjd$1@mws-stat-syd.cdn.telstra.com.au>

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