Re: compile index error

Posted by Roshan on Oct 13, 2016; 5:15pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/compile-index-error-tp1395p1398.html

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.