ORA-28221 REPLACE not specified

Database Version: Oracle 11g
User status:expired(grace)

PROBLEM:

Password complexity is enabled with custom function.I’m trying to change the password of my user and I’m getting this error.

SQL> alter user omerfrkbzkrt identified by new_password;
ORA-28221 REPLACE not specified

SOLUTION:

SQL> alter user omerfrkbzkrt identified by new_password replace old_password;

Reference: http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_4003.htm#SQLRF53632

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s