ORA-14287: cannot REBUILD a partition of a Composite Range partitioned index

Symptoms:

SQL> ALTER INDEX IDX_TRANSACTION_DATA_CP_TIME rebuild partition M_2016_09_SP5 ONLINE;

ALTER INDEX IDX_TRANSACTION_DATA_CP_TIME rebuild partition M_2016_09_SP5 ONLINE

*

ERROR at line 1:

ORA-14287: cannot REBUILD a partition of a Composite Range partitioned index

Solution:

Rebuild index sub-partition not index partition. You can see the name of the sub-partition, example:

SQL> select index_name name,partition_name partition,subpartition_name Subpartition,status from all_ind_subpartitions i where I.INDEX_NAME='IDX_TRANSACTION_DATA_CP_TIME';

SQL> ALTER INDEX IDX_TRANSACTION_DATA_CP_TIME rebuild subpartition M_2016_09_SP5 ONLINE;

Index altered.