A-00910: specified length too long for its datatype

 

Error: 

ORA-00910: specified length too long for its datatype

Cause:

The above error message while creating table with string data types of below length:

- VARCHAR2(4001), where length is greater than 4000.

- NVARCHAR2(2001), where length is greater than 2000.

- RAW(2001), where length is greater than 2000.

Solution:

Max_string_size needs to be modified from STANDARD to EXTENDED.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup upgrade
ORACLE instance started.

Total System Global Area 2097152000 bytes
Fixed Size                  3047568 bytes
Variable Size             503320432 bytes
Database Buffers         1040187392 bytes
Redo Buffers               13725696 bytes
In-Memory Area            536870912 bytes
Database mounted.
Database opened. 

SQL> alter system set max_string_size = EXTENDED;
System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.

Total System Global Area 2097152000 bytes
Fixed Size                  3047568 bytes
Variable Size             503320432 bytes
Database Buffers         1040187392 bytes
Redo Buffers               13725696 bytes
In-Memory Area            536870912 bytes
Database mounted.
Database opened.