Thursday, January 3, 2013

ORA-14060 - Partition key can not be changed


When you want to partition a table be careful about the datatype and length of tahat column, because you can not issue an ALTER command to modify it.
For example, when trying to change the partition column data type from data to timestamp, following error appears:

ALTER TABLE PARTITION_TABLE MODIFY (create_time TIMESTAMP)

Error report:
SQL Error: ORA-14060: data type or length of a table partitioning column may not be changed
14060. 00000 -  "data type or length of a table partitioning column may not be changed"
*Cause:    User issued ALTER TABLE statement attempting to modify
           data type and/or length of a column used to partition the
           table named in ALTER TABLE statement, which is illegal
*Action:   Avoid modifying data type and/or length of table
           partitioning column(s)

No comments:

Post a Comment