- Get the current value of the password from dba_users table and save it
- Reset the password for temporary purpose using “alter user system identified by <temp password>;” and do your activities with the system user with new password
- Reset back to the old password by using
- Select the user password from sys.user$ table.
- Reset the user password with the temp password
- Reset back the user password to the original old value