Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

removing database links

602576Nov 17 2007 — edited Nov 19 2007
Hi, i have problem with deleting database links.

There are several db links which looks like this:

dblink1.world
dblink2.world
dblink3 (private)
dblink4 (public)

global names set to false
database global name look like test.world
sqlnet.ora has domain = world entry

Links dblink3 and dblink4 were created be before changing global name to test.world and changing values in sqlnames.ora

Problem:

when i try to delete db link using:

drop database link link3;
drop public database link dblink4;

i am always getting error that db link doesn't exist, however i can clearly see it in dba_db_links view.

Any ideas how to drop those links.


M.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 17 2007
Added on Nov 17 2007
7 comments
4,761 views