Oracle Error ORA-14061: data type or length of an index partitioning column may not be changed

Oracle 184 Views 0 Min Read

Oracle Error Message

ORA-14061: data type or length of an index partitioning column may not be changed

Reason for the Error

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

Solution

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

Tags: