ORA-1450 occurs on create index when "max_string_size=extended"
(Doc ID 2747652.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 19.9.0.0.0 [Release 12.1 to 19]Information in this document applies to any platform.
Purpose
SQL> show parameter MAX_STRING_SIZE
NAME TYPE VALUE
------------------------------------ ----------- -----------------------
max_string_size string EXTENDED
SQL> create table t1 (c1 varchar2 (32767));
Table created.
SQL> create index i1 on t1 ( TO_CHAR (c1) );
create index i1 on t1 ( TO_CHAR (c1) )
*
ERROR at line 1:
ORA-01450: maximum key length (6398) exceeded
SQL> create table t1 (c1 clob);
Table created.
SQL> create index i1 on t1 ( TO_CHAR (c1) );
create index i1 on t1 ( TO_CHAR (c1) )
*
ERROR at line 1:
ORA-01450: maximum key length (6398) exceeded
Details
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Purpose |
| Details |
| References |