Restrictions when altering a column's data type

 

When altering a column's data type, and that column is part of a partitioning key, there are some restrictions on the target data type.

For range partitioning, the data type of a column used to partition a table cannot be changed to BLOB, CLOB, DBCLOB, DATALINK, floating-point type, or a distinct type based on the these types. For hash partitioning, the data type of the column used as part of the partition key cannot be changed to LOB, DATE, TIME, TIMESTAMP, floating-point type, or a distinct type based on one of these.

 

Parent topic:

Modification of existing partitioned tables

 

Related reference

ALTER TABLE