Oracle user password is encrypted in view DBA_USERS.PASSWORD. Under many situation, administrators require to perform some task using those user. A work around is to change the password temporary and change it back after use. This apply when dropping database link.
- Retrieve and noted encrypted password from DBA_USERS.PASSWORD. Says its value is BE4321DD479FE6AB
- Change to user password using alter user iccs identified by iccsdba;
- Login with new password: connect iccs/iccsdba
- After work is done. change the password back: alter user iccs identified by values 'BE4321DD479FE6AB'