Oracle Database 12c New Features

ORA-14266: data type or length of an index subpartitioning column may not be changed

ORA-14266: data type or length of an index subpartitioning column may not be changed


Cause:


User issued ALTER TABLE statement attempting to modify data type and/or length of a column used to subpartition some index defined on the table named in ALTER TABLE statement, which is illegal



Action:


Avoid modifying data type and/or length of index subpartitioning column(s)