Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to change database password in TOAD

2632048Nov 4 2014 — edited Nov 4 2014

Hello,

I have been trying to use the following sql in order to change the passwords of my databases so they all are in sync. I used the same query a month ago

https://community.oracle.com/thread/3611584

which worked fine but I having been experiencing error past few days. Please help me figure this out.

Error:

ORA-00922: missing or invalid option

Sql Query I have been using:

ALTER USER user_name IDENTIFIED

by aBcd_1234 --new password

REPLACE aBcd@123 --old password

;

commit

;

I use:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

TOAD for Oracle Base Version 11.5.1.2

Appreciate your help!

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 2 2014

Added on Nov 4 2014

#general-database-discussions

8 comments

3,195 views