ORA-28221错误是一个Oracle数据库错误代码,具体错误信息为“REPLACE not specified”。这个错误通常出现在尝试修改用户密码时,但没有按照数据库的安全策略正确执行修改操作。 2. ORA-28221错误可能的原因 密码复杂性函数启用:数据库启用了密码复杂性验证功能,这通常通过执行UTLPWDMG.SQL脚本或在用户profile中设置PASSWORD_...
ERROR at line 1: ORA-28221: REPLACE not specified $ oerr ora 28221 28221, 00000, "REPLACE not specified" // *Cause: User is changing password but password verification function is // turned on and the original password is not specified and the // user does not have the alter user syste...
* 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.
When a user name has a profile that has a password verify function set and the user tries to change the password using “ALTER USER” without the REPLACE clause, and also the user doesn’t have ALTER USER privilege Oracle will generate the “ORA-28221: REPLACE not specified” error message...
There is also another way, if you are not able to change password by the previous command, but you must know old password: ALTERUSERmy_user IDENTIFIEDBYmy_password REPLACE my_old_password; Just one more trick in Oracle, that you should know…...
ORA-28221 REPLACE clause not specified Cause An attempt was made to change the password with the password verification function enabled and the original password was not specified in the REPLACE clause. This is required if the user does not have ALTER USER system privilege. Action Provide the ...
2707 ORA-28221: REPLACE not specified cpssh11 1 ORA-06512: at "SYS.EXECASUSERID", line 41 ORA-06512: at "SYS.DBMS_SYS_SQL", line 1529 ORA-06512: at "SYS.EXECASUSERID", line 19 ORA-06512: at "SYS.EXECASUSER", line 25