database link

I hope someone will help me to solve my problem:

IŽd like to create a database link between two personal 8 databases on two different NT servers.

I have registered them as test_1.world and test_2.world name_services in Net8 easy config.

user scott created a database link as follow:

create database link test_2.world connect to scott identified by tiger using 'test_2.world';
Database link created.

When scott tries to query table emp_at_test_2.world I always get following error message:

ERROR:
ORA-02085: database link TEST_2.WORLD connects to ORACLE.WORLD

I know this problem has something to do with the default domain in global_name but I dont know what to do.

Please give me some hints!

Thank you, Michael

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon May 31 1999 - 07:23:33 CDT