How to reset an expired database user without changing the password?

The simple method to reset a user is changing the password. If you dont have chance to change the password and if you can not remember the old one, you can use the following method:

select dbms_metadata.get_ddl('USER', u.username) AS ddl 
from  dba_users u 
where u.username = 'HR';

You can find the hashed passwords for all users in the database with this query.

After that you can set the old password and reset the account.

alter user HR identified by values 'S:ASSDSKDEIRUIERUTEUYTEIEORIEORIEPORI;ERIUERIUTY';


----