SumanKumar
SumanKumar

Reputation: 364

Identifier is too long issue in Oracle 12.2

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

Answers (1)

Related Questions