ORA-14060 or ORA-14265 when modifying column definition
(Doc ID 330964.1)
Last updated on JANUARY 30, 2022
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: 126.96.36.199 and higher
You are trying to modify a column, for example:
- changing a CHAR or VARCHAR2 column from BYTE semantics to CHAR semantics (or the other way around)
- changing the length of a column (either a number of of a (var)char column).
- etc. etc.
Because this column is used as a partition key, this change is not allowed and you receive:
ORA-14060: data type or length of a table partitioning column may not be changed
Alternatively when modifying a subpartition key, you would receive:
ORA-14265: data type or length of a table subpartitioning column may not be changed
This is also a possible problem when doing a character set change from single byte to multi byte ( AL32UTF8 typically) or from UTF8 to AL32UTF8 and there are partition keys in the database that contain columns defined with character length semantics .
There cannot be any (sub)partition keys who use CHAR semantics seen the byte lenght "behind the scene" changes during the character set change and the alter database/Csalter or DMU tool will fail.
This select will give all partitioned tables using char semantics columns:
You are trying to change the definition of a column that acts as a (sub)partition key.
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