Oracle Error ORA-14271: table is not partitioned by Composite Range method

Oracle Error Message

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

Reason for the Error

The table in ALTER TABLE MODIFY SUBPARTITION { UNUSABLE LOCAL INDEXES | REBUILD UNUSABLE LOCAL INDEXES } statement is not partitioned by Composite Range method which is illegal.

Solution

Ensure that the table is partitioned by Composite Range method