Database links after database filecopy

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 :confused:

Thanks for advice,
romain.

Hope this helps in your situation.

select * from global_name;

alter database rename global_name to test;
drop database link vtt;


Once the link is dropped, you can rename the global name back.

Regards,
Seelan

Some things are so easy and only look so difficult to resolve:)

Thank you!