SQL> show parameter max_string;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
max_string_size string EXTENDED
----------
CREATE TABLE TABLE_TEST ("OBJECT1" NUMBER, "OBJECT2" NUMBER, "NAME" VARCHAR2(100 BYTE) COLLATE "USING_NLS_COMP" );
Error report -
ORA-43929: Collation cannot be specified if parameter MAX_STRING_SIZE=STANDARD is set.
43929. 0000 - "Collation cannot be specified if parameter MAX_STRING_SIZE=STANDARD is set."
*Document: YES
*Cause: The COLLATE or DEFAULT COLLATION clause was specified in a DDL
statement or the DEFAULT_COLLATION parameter was specified in an
ALTER SESSION statement, but the value of the initialization
parameter MAX_STRING_SIZE was STANDARD. The data-bound collation
feature is disabled if the value of this parameter is STANDARD.
*Action: Set MAX_STRING_SIZE to EXTENDED by following the procedure
documented in the Oracle Database Reference.