As of Oracle Database 12cR2 (12.2.0.1+), the maximum length of most identifiers is now 128 characters -- including USERNAME.

pepperB wrote on Thu, 14 May 2020 19:06

As of Oracle Database 12cR2 (12.2.0.1+), the maximum length of most identifiers is now 128 characters -- including USERNAME.

but ONLY if you

ALTER SYSTEM SET max_string_size=extended;

Please note that once you do that, you can never go back to the old sizes

.. yes, why reopen such an old thread.

If COMPATIBLE is set to a value of 12.2 or higher, then names must be from 1 to 128 bytes long with these exceptions:

Names of databases are limited to 8 bytes.

Names of disk groups, pluggable databases (PDBs), rollback segments, tablespaces, and tablespace sets are limited to 30 bytes.

SQL> show parameter max_string_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
max_string_size                      string      STANDARD
SQL> create table t12345678901234567890123456789012345678901234567890(id number);

Table created.

SQL>