Skip to Main Content

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!

Change Password ORA-00972: identifier is too long

happy10319May 10 2019 — edited May 11 2019

Hi,

On 12.2C on Linux:

I recoverd password value from database :

select spare4 from sys.user$ where name='user1';

But

When running alter user to change password:

ALTER USER user1 identified by values "2D80AC1C0382FD472ECE7FB6614E2090173223B5635CD88491C67A9CE8C96AF34897452EFDB8B69E5CDD43213596D76CFF5F223E97BB2EF584082E451B85245E8F43FB631B97DA39ADBB570703B79886DE9411B043502B5C0AD25BDA929450E9FDE036D43206D3B8S"

                                    *

ERROR at line 1:

ORA-00972: identifier is too long

What is the solution?

Thank you.

This post has been answered by L. Fernigrini on May 10 2019
Jump to Answer
Comments
Post Details
Added on May 10 2019
8 comments
1,741 views