ORA-28007: the password cannot be reused

SQL> select USER#,NAME,PASSWORD FROM user$ where name='APPS_VIEW';

　

USER# NAME PASSWORD

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

329 APPS_VIEW 32B8112B2AB331

　

　

select * from dba_profiles where profile='DBUSER' and RESOURCE_NAME in ('PASSWORD_REUSE_TIME') ;

SELECT *

FROM dba_users

WHERE USERNAME='APPS_VIEW';

　

RESTRICTIVE

　

SELECT PROFILE FROM dba_users WHERE USERNAME='APPS_VIEW';

　

alter profile RESTRICTIVE limit PASSWORD_REUSE_TIME UNLIMITED;

alter profile RESTRICTIVE limit PASSWORD_REUSE_TIME 360;

　

select username,account_status,EXPIRY_DATE from dba_users where username='APPS_VIEW';

alter user APPS_VIEW identified by donotchange;

　

SQL> alter profile default limit PASSWORD_REUSE_MAX unlimited;

　

SQL> alter user USERNAME identified by <PREV_PWD>

　

SQL> alter profile default limit PASSWORD_REUSE_MAX unlimited;



SQL> alter user USERNAME identified by <PREV_PWD>

　

alter profile RESTRICTIVE limit PASSWORD_REUSE_MAX unlimited;

=======================================================

　

SQL> alter profile RESTRICTIVE limit PASSWORD_REUSE_MAX unlimited;

　

Profile altered.

　

SQL> alter user APPS_VIEW identified by hange;

　

　

=======================================================