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: Will Kramer <willardkNOSPAM_at_email.com>
Date: Thu, 01 Mar 2001 20:57:46 GMT
Message-ID: <3a9eb79f.620543364@News.CIS.DFN.DE>

can you give an example of a remote conect string??

thanks,
Will

On Thu, 1 Mar 2001 09:56:10 +0100, "Ian Ledzion" <ian.ledzion_at_xlgbow.com> wrote:

>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 - 14:57:46 CST

Original text of this message

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