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 -> Re: Help Please For Create Database Link

Re: Help Please For Create Database Link

From: Markus Korn <markus.korn_at_at.siemens.de>
Date: Fri, 25 Jun 1999 13:31:25 +0200
Message-ID: <3773688D.BD9CD8D3@at.siemens.de>


You are using a sqlnetV1 connect string, change it to your alias which is specified in your tnsnames.ora, because i think sqlnetV1 is not supported oracle version above 7.3.3 but maybe i am wrong, but i know oracle8 supports just net80 and sqlnetv2

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';
>
> 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:31:25 CDT

Original text of this message

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