Re: Cross database joins in Oracle 8.0

From: <illasreenu_at_my-deja.com>
Date: 2000/05/23
Message-ID: <8genk8$vi7$1@nnrp1.deja.com>#1/1

You have to use a DB Link in oracle to access the second database tables from the first one. Once you have the DB link, then you can use the tables from the second database as you use the ones from the first one. Only difference will be that you have to use the DB link name with the table names.

Hope this helps you.

Thanks,
Sreeni
In article <8gec61$mso$1_at_nnrp1.deja.com>, acf4cga_at_my-deja.com wrote:
> Hi,
> I'm trying to do a cross database join between 2 tables where one
table
> resides in one database and the 2nd resides in another database. Both
> databases are on the same Oracle 8.0 machine.
> I know how to this in SQL Server 7.0 using the
> databasename.username.tablename syntax.
> Does anyone know how to do this in Oracle?
>
> Thanks,
> Charles.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue May 23 2000 - 00:00:00 CDT