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';

NAME

PARTITION

SUBPARTITION

STATUS

IDX_TRANSACTION_DATA_CP_TIME

M_2016_08

M_2016_08_SP6

USABLE

IDX_TRANSACTION_DATA_CP_TIME

M_2016_08

M_2016_08_SP7

USABLE

IDX_TRANSACTION_DATA_CP_TIME

M_2016_08

M_2016_08_SP8

USABLE

IDX_TRANSACTION_DATA_CP_TIME

M_2016_09

M_2016_09_SP1

USABLE

IDX_TRANSACTION_DATA_CP_TIME

M_2016_09

M_2016_09_SP2

USABLE

IDX_TRANSACTION_DATA_CP_TIME

M_2016_09

M_2016_09_SP3

USABLE

IDX_TRANSACTION_DATA_CP_TIME

M_2016_09

M_2016_09_SP4

USABLE

IDX_TRANSACTION_DATA_CP_TIME

M_2016_09

M_2016_09_SP5

USABLE

IDX_TRANSACTION_DATA_CP_TIME

M_2016_09

M_2016_09_SP6

USABLE

IDX_TRANSACTION_DATA_CP_TIME

M_2016_09

M_2016_09_SP7

USABLE

IDX_TRANSACTION_DATA_CP_TIME

M_2016_09

M_2016_09_SP8

USABLE

IDX_TRANSACTION_DATA_CP_TIME

M_2016_10

M_2016_10_SP1

USABLE

IDX_TRANSACTION_DATA_CP_TIME

M_2016_10

M_2016_10_SP2

USABLE

IDX_TRANSACTION_DATA_CP_TIME

M_2016_10

M_2016_10_SP3

USABLE

IDX_TRANSACTION_DATA_CP_TIME

M_2016_10

M_2016_10_SP4

USABLE

IDX_TRANSACTION_DATA_CP_TIME

M_2016_10

M_2016_10_SP5

USABLE

IDX_TRANSACTION_DATA_CP_TIME

M_2016_10

M_2016_10_SP6

USABLE

IDX_TRANSACTION_DATA_CP_TIME

M_2016_10

M_2016_10_SP7

USABLE

 

SQL> ALTER INDEX IDX_TRANSACTION_DATA_CP_TIME rebuild subpartition M_2016_09_SP5 ONLINE;

Index altered.

Comments