Oracle Database 12c New Features

ORA-14253: table is not partitioned by Composite Range method

ORA-14253: table is not partitioned by Composite Range method


Cause:


The table in a subpartition maintenance operation (ALTER TABLE EXCHANGE/MODIFY/MOVE/TRUNCATE SUBPARTITION, or ALTER TABLE MODIFY PARTITION ADD/COALESCE SUBPARTITION command must be partitioned by Composite Range method



Action:


Ensure that the table is partitioned by Composite Range method