Re: Joining tables from two separate oracle databases possible

The Cnnect Sring is user defined when you set up your TNSNAMES.ORA file (if you take that route). In the case of a DB link, connect string used is the one from TNSNAMES.ORA file on your server, so you have to ensure that there's consistency across your system.

The naming convention we use is Server_Application_Environment, so an example would be: DBS1_ACCT_TEST, DBS1_ACCT_PROD etc..

"Will Kramer" <willardkNOSPAM_at_email.com> wrote in message news:3a9eb79f.620543364_at_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 Fri Mar 02 2001 - 01:40:18 CST