Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Distributed Database
Create a database link to the remote system. You can then join tables from all of your linked databases. (No, I never tried it, but I recall attending a demo where one query accessed three databases located in three different cities.)
>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 4/19/00, 3:33:45 PM, Ulrich Jankrift <ulrich.jankrift_at_t-online.de> wrote regarding Distributed Database:
> Hi!
> I have several DB-Server running Oracle 7.3.4. How can I start a query
> over all databases? (e.g. joining two tables of diff. servers)
> many thanks
> Ulrich Jankrift
Received on Thu Apr 20 2000 - 00:00:00 CDT