ORA-28221: REPLACE not specified

Cause : ORA-28221 error occurs when an user tries to reset his own password without specifying the REPLACE keyword, provided the user does not have ALTER USER privilege and the user is having a profile with password verify function.
Solution : Provide the current password along with the REPLACE clause in the ALTER USER statement.

SQL> conn test/test_pwd12
Connected.
SQL> alter user test identified by test_pwd11;
alter user test identified by test_pwd11
*
ERROR at line 1:
ORA-28221: REPLACE not specified

SQL> alter user test identified by test_pwd11 replace test_pwd12;
User altered.
SQL> conn test/test_pwd11
Connected.

 

Article by : Anju