Procedure to set old password

setting password > 

If database user 'oxford' or application user password is expired and he want's to use old password 

Procedure as follows 

SQL> select SPARE4 from sys.user$ where name='OXFORD';

SPARE4

--------------------------------------------------------------------------------

S:75C6294AF9823AF42A8BC83BE2FB03A0727988159F34241B4211E71FC1AB

SQL> alter user oxford identified by values 'S:75C6294AF9823AF42A8BC83BE2FB03A0727988159F34241B4211E71FC1AB';

User altered.

SQL> conn oxford/oracle;

Connected.

--Nikhil Tatineni--

--Oracle--