ORA-28007: the password cannot be reused

 

Profile의 정책 설정에 따른  PASSWORD_REUSE_MAX or PASSWORD_REUSE_TIME 의 제약에 따라 같은 암호 설정시 발생!!
ORA-28007: the password cannot be reused 

 

귀차니즘으로 인하여 패스워드를 재사용하고 싶다면..

1. 해당유저의 user id 확인

SELECT username, user_id
FROM dba_users
WHERE username='<USERNAME>';

2. Password History 에 관련된 row 를 삭제

SQL> DELETE FROM sys.user_history$ WHERE user#=<user_id from Step 1>;
SQL> commit;

SQL> select * from sys.user_history$ WHERE user#=<user_id from Step 1>;