Xref: alice comp.databases.oracle.misc:49098 comp.databases.oracle.server:77496
Path: alice!news-feed.fnsi.net!newsfeed.icl.net!news.algonet.se!newsfeed1.telenordia.se!algonet!newsfeed1.funet.fi!news.eunet.fi!EU.net!newssrv.ita.tip.net!hermes.libero.it!typhoon.libero.it!not-for-mail
From: "Davide Saya" <dvdsya@libero.it>
Newsgroups: comp.databases.oracle.server,comp.databases.oracle.misc
References: <3850d5a4.147253469@news.cs.tu-berlin.de>
Subject: Re: using two databases with one SQL statement
Lines: 29
X-Newsreader: Microsoft Outlook Express 4.72.2106.4
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Message-ID: <w%N44.18805$Bg7.191660@typhoon.libero.it>
Date: Sun, 12 Dec 1999 14:08:28 GMT
X-Complaints-To: abuse@libero.it
X-Trace: typhoon.libero.it 945007708 151.20.74.13 (Sun, 12 Dec 1999 15:08:28 MET)
NNTP-Posting-Date: Sun, 12 Dec 1999 15:08:28 MET
Organization: [Infostrada]

yes, it is.

The required object is a DB LINK.

a DBLINK allows you to reference objects in a remote oracle instance,

select ..... from
table_in_current_db,
table_in_remote_db@dblink_to_remote_db;

When creating a dblink you give it a user and a password, be sure that this
user is allowed to operate on the object you reference.


Dirk Gómez ha scritto nel messaggio
<3850d5a4.147253469@news.cs.tu-berlin.de>...
>Hullo,
>
>is it possible to work with two Oracle databases with one SQL
>statement. Something like this:
>
>Select * from <database_a>, <database_b> where
><database_a>.table_a.field1= <database_b> .table_b.field3
>
>cheers Dirk