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

Home -> Community -> Usenet -> c.d.o.server -> Re: Access to different Oracle (8i) Databases in one SQL

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

From: oracle1 <santyspamsharma_at_hotmail.com>
Date: Tue, 4 Mar 2003 19:34:35 -0800
Message-ID: <b43r3r$1rtgfl$1@ID-84096.news.dfncis.de>


read "database links" on tahiti.oracle.com.

santysharma

"AnotherUser" <AnotherUser_at_abc.com.au> wrote in message news:b43ouu$gjd$1_at_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 - 21:34:35 CST

Original text of this message

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