The Administrator cannot delete the DB Link created by other users.

The Administrator cannot delete the DB Link created by other users (for example, emcd ):

(1) you can log on to the database as an administrator, query dba_users, and write down the values of the user's emcd password:

SQL> select username, password from dba_users where username = 'emcd ';

USERNAME PASSWORD

---------------------------

EMCD 73401EA912C54B8C

Then modify the user's emcd password:

SQL> alter user emcd identified by emcd123;

The user has changed.

(2) log on to the database with the user emcd and the new password emcd123, and delete the DB Link it owns:

SQL> conn emcd/emcd123;

Connected.

SQL> drop database link ttt1;

The database link has been deleted.

(3). log on to the database as an administrator and change the password of emcd back to the original value:

SQL> conn sys as sysdba;

Enter the password:

Connected.

SQL> alter user emcd identified by values '73401ea912c54b8c ';

The user has changed.

At this time, the password has been changed to the original value.

In fact, the original password is emcd. You can test whether the password has been changed:

SQL> conn emcd/emcd;

Connected.