This content has been marked as final. Show 3 replies
change account password.1 person found this helpful
alter profile default limit PASSWORD_LIFE_TIME UNLIMITED;
expired means that your password is too old not blocked, you must change it:1 person found this helpful
alter user <username> identify by <new_password>;
in your profile you has set PASSWORD_LIFE_TIME = X days, if your user password has more than X days it will expired. You can set another value or unlimited to password_life_time to make the password forever (not recommended) or more life time.
Edited by: Fran on 03-dic-2012 2:07
To unexpire and account simply assign a new password to the user.
eg: alter user USER_ACCOUNT identified by NEW_PASSWORD