data base link

From: Search <leeuw26_at_yahoo.com>
Date: Wed, 14 Apr 2004 16:22:05 +0200
Message-ID: <407d48d3$0$917$a0ced6e1@news.skynet.be>

I have oracle 8.1.7.
the tnsnames.ora is ok .
With the connect function I can connect to the remote database. BUT when I use the create database link command then it goes wrong.

I can create the database link but when I try a simple select * from ..._at_databaselink , I
recieve following error : tns servicename could not be resolved.

But that is not true because I configured the tnsnames.ora well and that works.

Could it be the the database link uses another file then tnsnames.ora ?

How could I fix this problem?

rgds

Gerry Received on Wed Apr 14 2004 - 09:22:05 CDT