Hi all,
I tried to drop a database link as 'SYS' user
(but database link was already created by some database users).
SQL> show user;
USER is "SYS"
SQL> select owner, db_link, username, created from sys.dba_db_links;
OWNER DB_LINK USERNAME CREATED
------------------------------ -------------------------------- ------------------------------ ---------
SCOTT CRMSDB SCOTT 26-OCT-16
SQL> select name , userID, PASSWORDX from sys.link$ where name='CRMSDB';
NAME USERID PASSWORDX
-------------------------------- ------------------------------ ----------------------
CRMSDB SCOTT 05ADCE5EF92CF371CF5A33F9DB315012FD
SQL> drop database link crmsdb;
drop database link crmsdb
*
ERROR at line 1:
ORA-02024: database link not found
SQL> conn scott
Enter password: *****
Connected.
SQL> drop database link crmsdb;
Database link dropped.
DB : 11.2.0.4.0