Reputation: 364
I heard that from 12.2 Oracle started supporting longer identifiers (i.e., up to 128 characters). But the following statement is still throwing ORA-00972: identifier is too long error at line number 2!!. I meant I can define user name with >30 characters but not the password.
CREATE USER xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
IDENTIFIED BY xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP QUOTA UNLIMITED ON USERS;
GRANT CREATE SESSION, RESOURCE, CREATE VIEW, CREATE MATERIALIZED VIEW, CREATE SYNONYM, UNLIMITED TABLESPACE TO xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx;
Note: My database version is Oracle 12.2.0.1.0 and I have also ensured that the compatibility of my database is 12.2.0
Upvotes: 1
Views: 1299