Cannot drop public database link
Hi all.
Just trying to drop some old database links and getting the following:
SQL> select * from dba_db_links where host = 'V638';
OWNER DB_LINK USERNAME HOST CREATED
---------- ---------------------------------------- ------------------------------ ---------- ---------
PUBLIC V638 SYSADM V638 23-SEP-04
SQL> drop public database link V638;
drop public database link V638
*
ERROR at line 1:
ORA-02024: database link not found
There was another db link in there called V638.WORLD and when I issued
drop public database link v638 it removed that one with no errors...
Any way I can get rid of this other one?
Version info:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for Solaris: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production
Thanks