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. |