-
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
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|