Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Joining tables from two separate oracle databases possible
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
![]() |
![]() |