Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help Please For Create Database Link
Anonymous wrote:
> I have 2 databases in the same machine.
>
> Database 1 : db1 (ORACLE_SID)
> with an user u1
>
> Database 2 : db2 (ORACLE_SID)
> with an user u2
>
> I would like to use u2's objects in db2
> when I'm connecting u1 in db1.
>
> So, I create a database link by connecting with u1 with the following
> command :
>
> CREATE DATABASE LINK u_link CONNECT TO U2 IDENTIFIED TIGER
> USING 'T:175.123.25.1:db2';
Why don't you use:
CREATE DATABASE LINK u_link CONNECT TO U2 IDENTIFIED TIGER
USING 'db2';
It should work.
> Then, in SQLPLUS, I type the following command :
>
> select * from u2.EMP_at_u_link;
>
> And I have an error "ORA 06401 : NETCMN: invalid driver designator"
>
> Can anyone help me please ?
>
> Thank.
>
> --------== Posted Anonymously via Newsfeeds.Com ==-------
> Featuring the worlds only Anonymous Usenet Server
> -----------== http://www.newsfeeds.com ==----------
Received on Fri Jun 25 1999 - 06:07:17 CDT