data base link
From: Search <leeuw26_at_yahoo.com>
Date: Wed, 14 Apr 2004 16:22:05 +0200
Message-ID: <407d48d3$0$917$a0ced6e1_at_news.skynet.be>
Date: Wed, 14 Apr 2004 16:22:05 +0200
Message-ID: <407d48d3$0$917$a0ced6e1_at_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 - 16:22:05 CEST