失效查询监控语句:
普通索引:
SELECT owner, index_name, tablespace_name
FROM dba_indexes
WHERE status = 'UNUSABLE';
分区索引:
SELECT index_owner, index_name, partition_name, tablespace_name
FROM dba_ind_PARTITIONS
WHERE status = 'UNUSABLE';
子分区索引:
SELECT index_owner,
index_name,
partition_name,
subpartition_name,
tablespace_name
FROM dba_ind_SUBPARTITIONS
WHERE status = 'UNUSABLE';
对应的批量生成修复脚本:
SELECT 'alter index ' || owner || '.' || index_name ||
' rebuild tablespace ' || tablespace_name || ';'
FROM dba_inde