Showing results for 
Search instead for 
Do you mean 
Solved! Go to solution

Renew schema password

Good morning,


while retrying to import an old schema, I got the message above. I have searched the admin manager, but can´t find any option to change the password for the schema user.


Where can I change the password?





Accepted by topic author thebang2
‎08-26-2015 04:32 AM

Re: Renew schema password



The problem is related to the Schema password expiring in Oracle.  Attached is a pptx that shows how to change the password and set it to never expire.

Re: Renew schema password

That´s it - thank you! Smiley Happy

Re: Renew schema password

Okay, still does not work.
I´ve followed your manual for both profiles, but I´ve still got the message "ERROR:
ORA-28011: the account will expire soon; change your password now".

Is it possible to change the password in the gui?

Re: Renew schema password

Okay, I have managed the problem - one of my sqlplus accounts was still expired, but you can list all accounts with the following command:


select username,exiry_date,account_status from dba_users;


Than you can repair the exired account like in the slution above - maybe it´s helpful for someone who is not that familiar with sqlplus.