Re: Report error

Posted by ErmanArslansOracleBlog on Mar 23, 2016; 7:23am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Report-error-tp746p750.html

Please read my updates carefully. Did you check index partitions?
Anyways, use this to produce the alter statements for you.

select 'alter index '||owner||'.'||index_name||' rebuild;' from dba_indexes where status='UNUSABLE';
select 'alter index '||index_owner||'.'||index_name||' rebuild partition '||partition_name||';' from dba_ind_partitions where status='UNUSABLE';
select 'alter index '||index_owner||'.'||index_name||' rebuild subpartition '||subpartition_name||';' from dba_ind_subpartitions where status='UNUSABLE';