Cause: 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. See the solution below.
Error solution: Ensure that the table is partitioned by Composite Range method
Database version: Oracle 11g Release 2 (11.2)