help: can't create database link

From: <badstreetboy_at_my-dejanews.com>
Date: Sat, 07 Nov 1998 01:08:10 GMT
Message-ID: <7206hq$3ri$1@nnrp1.dejanews.com>

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 - 19:08:10 CST