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 10.2.0.1.0 – Production on Sun Jun 12 12:57:05 2011

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

ERROR:
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 10.2.0.1.0 – Production
With the Partitioning, OLAP and Data Mining options

SQL>

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>