removing database links
602576Nov 17 2007 — edited Nov 19 2007Hi, 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.