compile index error

[Roshan]

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

[Roshan]

I am checking the doc (Doc ID 2059614.1)

The view DBA_INDEX_SUBPARTITIONS does not exist

[ErmanArslansOracleBlog]

Check: DBA_IND_SUBPARTITIONS

[Roshan]

Is the query ok?

select 'ALTER INDEX ' || index_owner || '.' || index_name || ' REBUILD SUBPARTITION ' ||
subpartition_name || ';'from dba_ind_subpartitions where index_name in (select index_name from dba_indexes where status='N/A');

I started executing it.

[ErmanArslansOracleBlog]

It s just a dynamic sql. It will return the statements that you need to execute. That is , you ll execute the output of that query.

13 Eki 2016 20:23 tarihinde "Roshan [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

Is the query ok?

select 'ALTER INDEX ' || index_owner || '.' || index_name || ' REBUILD SUBPARTITION ' ||
subpartition_name || ';'from dba_ind_subpartitions where index_name in (select index_name from dba_indexes where status='N/A');

I started executing it.

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/compile-index-error-tp1395p1398.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML