Re: Joining tables from two separate oracle databases possible

From: Ian Ledzion <ian.ledzion_at_xlgbow.com>
Date: Thu, 1 Mar 2001 09:56:10 +0100
Message-ID: <97l2re$ip$1@rex.ip-plus.net>

Have you tried a Database link?

CREATE DATABASE LINK my_link USING '<remote_connect_string>';

You can refer to tables in the remote DB using:

SELECT * FROM EMP_at_my_link

"Will Kramer" <willardkNOSPAM_at_email.com> wrote in message news:3a9d5b92.531442353_at_News.CIS.DFN.DE...
> 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 Thu Mar 01 2001 - 02:56:10 CST