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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Joining tables from two separate oracle databases possible

Re: Joining tables from two separate oracle databases possible

From: Ed Prochak <ed.prochak_at_magicinterface.com>
Date: Tue, 13 Mar 2001 03:40:40 GMT
Message-ID: <3AADC187.5D03E0D5@magicinterface.com>

You just need to create a database link to the other instances. You'll find it documented in the DBA manuals, not in the usual SQL manuals. They can be very useful at times, thought tricky on security issues.

HTH
Ed Prochak

Will Kramer wrote:

> I'm have oracle 8.1 client installed on my NT box and two databases I
> have access to via tcp/ip and mention in tnsnames.ora. Is there a way
> via sql to access both databases at the same time and do a simple
> join...like lastname to lastname???
>
> If not are there ways of doing this? do I need third party software?
>
> any help , or directions to the right spot would be greatly
> appreciated.
>
> regards,
> Will Kramer
Received on Mon Mar 12 2001 - 21:40:40 CST

Original text of this message

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