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!

Cannot drop public database link

user222828Feb 1 2010 — edited Feb 2 2010
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 2 2010
Added on Feb 1 2010
8 comments
2,993 views