Hello,

I recently set up a new Oracle database through a filecopy of all files. The database works fine (global_name looks fine, tnsnames.ora also).

On the source database (assume PRD.world) there was a database link to a remote database (assume VTT.world) and vice versa.

Now, through filecopy, the database link to the remote database (VTT.world) is on the same server. It so reacts as a loopback-database-link now.

And here's my problem:
If I try to drop the public database link on the VTT.world, Oracle tells me:

DROP PUBLIC DATABASE LINK vtt;

ERROR : ORA-02082: a loop-back database link must have a connection qualifier

It seems, after searching for this topic in different Newsgroups, that this loopback-link couldn't be dropped anymore

Thanks for advice,
romain.