index unusable

select 'ALTER INDEX '||p.index_owner||'.'||p.index_name||' REBUILD SUBPARTITION '||p.subpartition_name||' PARALLEL 8;'
from dba_ind_subpartitions p where status <>
'USABLE'

Hiç yorum yok: