Re: help: can't create database link

From: Dan Roberts <roberts_d_at_bms.com>
Date: Fri, 06 Nov 1998 22:53:01 -0500
Message-ID: <3643C41C.A1112A5C@bms.com>

I think in you INIT.ORA file you have to change the parameter called something like global names from true to false..Dan

badstreetboy_at_my-dejanews.com wrote:

> I tried to create a database link to access the db on another oracle server on
> another NT:
>
> create public database link nt2_link connect to user identified by passwd
> using 'nt2'; 'nt2' is the service name of the target oracle server which I
> have already set it in my init.ora file locally.
>
> However, this db link does not work. If I do a:
> select * from table_name_at_nt2_link;
>
> Oracle gave me an error:
> ORA-02085: database link NT2_LINK.WORLD connects to ORACLE.WORLD
>
> Anyone can help me? Thanks!!!
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Nov 06 1998 - 21:53:01 CST