compile index error

Posted by Roshan on Oct 13, 2016; 11:08am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/compile-index-error-tp1395.html

Hello Erman,

I am having an issue when compiling indexes.
'ALTERINDEX'||INDEX_OWNER||'.'||INDEX_NAME||'REBUILDPARTITION'||PARTITION_NAME||
--------------------------------------------------------------------------------
alter index HDBUSR.IX_EZTAX_OUT_TRANS rebuild partition P20161023;
alter index HDBUSR.IX_EZTAX_OUT_TRANS rebuild partition P20161018;
alter index HDBUSR.IX_SUBS_REFLECT_DETAIL_ID rebuild partition P20160715;
alter index HDBUSR.IX_SUBS_REFLECT_ID rebuild partition P20160916;
alter index HDBUSR.IX_TRANSAC_SCID rebuild partition P20161022;
alter index HDBUSR.IX_SUBS_REFLECT_DETAIL_ID rebuild partition P20160724;
alter index HDBUSR.IX_TRANSAC_D rebuild partition P20160912;

1030 rows selected.

SQL> alter index HDBUSR.IX_TRANSAC_ID rebuild partition P20160905;
alter index HDBUSR.IX_TRANSAC_ID rebuild partition P20160905
                   *
ERROR at line 1:
ORA-14287: cannot REBUILD a partition of a Composite Range partitioned index

Thanks,
Roshan