Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Database Link across 2 databases.
> 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