Rebuild UNUSABLE Partition Indexes

Validate and generate rebuild script for partition indexes

Select 'ALTER INDEX '||INDEX_OWNER||'.'||index_name ||' rebuild partition ' || PARTITION_NAME ||';'  from DBA_IND_PARTITIONS Where  status = 'UNUSABLE'