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

Home -> Community -> Usenet -> c.d.o.server -> Help Please For Create Database Link

Help Please For Create Database Link

From: Anonymous <nobody_at_newsfeeds.com>
Date: Fri, 25 Jun 1999 12:06:52 +0200
Message-ID: <37735215@anonymous.newsfeeds.com>


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';

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 - 05:06:52 CDT

Original text of this message

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