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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Database Link across 2 databases.

Re: Database Link across 2 databases.

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Thu, 21 Oct 1999 12:50:44 GMT
Message-ID: <380F0C24.DA4210A0@edcmail.cr.usgs.gov>

> You should write something like this
> create database link db1 connect scott identified by tiger USING db2;

I think you would probably want:
  create database link db1 connect scott identified by tiger USING db1;

The USING clause tells the db link which tnsnames entry to use so it knows which database to connect to. You could call the link name something non-related to the tnsnames entry.

HTH,
Brian Received on Thu Oct 21 1999 - 07:50:44 CDT

Original text of this message

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