I have installed Oracle 12c Release 2 on my windows 7 machine and created a new PDB. Now I am trying to create the following user with a password of length more than 30 characters I am getting "ORA-00972: identifier is too long error". Why I am getting this error? What is the default max length of a password in Oracle 12c Release 2?
FYI - I haven't configured any password complexity rules and I have also ensured my PDB compatibility level as "12.2.0"
CREATE USER xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
IDENTIFIED BY xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
/*The password length here is >30 characters*/
DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON USERS;