ORA-00972: identifier is too long

Tested on an Oracle 9 database. The maximum length of a password is 30 characters. If you try and set one longer than that, Oracle returns an ORA-00972:

 

SQL> CREATE USER A IDENTIFIED BY

  2  ABCDEFGHIJKLMNOPQRSTUVWXYZ1234

  3  /

 

User created.

 

SQL> ALTER USER A IDENTIFIED BY

  2  ABCDEFGHIJKLMNOPQRSTUVWXYZ12345

  3  /

ABCDEFGHIJKLMNOPQRSTUVWXYZ12345

*

ERROR at line 2:

ORA-00972: identifier is too long

 

SQL> CREATE USER B IDENTIFIED BY

  2  ABCDEFGHIJKLMNOPQRSTUVWXYZ12345

  3  /

ABCDEFGHIJKLMNOPQRSTUVWXYZ12345

*

ERROR at line 2:

ORA-00972: identifier is too long

 

SQL>