Database links after database filecopy
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,
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.
Some things are so easy and only look so difficult to resolve
Click Here to Expand Forum to Full Width