oracle-nls-semantics

ORA-01450: Maximum Key Length Exceeded – Possible Causes and Fix

Switch from char to byte, and restart the database:

SQL> ALTER SESSION SET NLS_LENGTH_SEMANTICS = 'BYTE'
  2  ;

Session altered.

SQL> show parameters nls_length_semantics

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_length_semantics                 string      BYTE
SQL> SQL>