If the user password has been expired how to recreate it?

SQL> alter user srk password expire;

User altered.

C:\Windows\system32>sqlplus srk/system

SQL*Plus: Release – Production on Sun Jun 12 12:57:05 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ORA-28001: the password has expired

Changing password for srk
New password:
Retype new password:
Password changed

Connected to:
Oracle Database 10g Enterprise Edition Release – Production
With the Partitioning, OLAP and Data Mining options


Leave a Comment

NOTE - You can use these HTML tags and attributes:
<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>