DB Link Drop Issue
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Solaris: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
SQL> select owner,db_link from dba_db_links;
OWNER DB_LINK
--------------- --------------------
APPS APPS_TO_APPS
APPS EDW_APPS_TO_WH
SQL> show user
USER is "APPS"
SQL>
SQL> drop database link APPS_TO_APPS;
drop database link APPS_TO_APPS
*
ERROR at line 1:
ORA-02024: database link not found
SQL> drop database link EDW_APPS_TO_WH;