Re: help: can't create database link

From: Andrew Protasov <oracle_at_protasov.kiev.ua>
Date: Sat, 7 Nov 98 08:40:55 +0200
Message-ID: <ABtj-GsK42@protasov.kiev.ua>

Hi,

Try

alter system set global_names=false;

Andrew Protasov

> 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 Sat Nov 07 1998 - 00:40:55 CST