Oracle索引状态查询&索引重建

检查损坏索引

SELECT status, COUNT(*)
  FROM dba_indexes
 GROUP BY status
UNION
SELECT status, COUNT(*)
  FROM dba_ind_partitions
 GROUP BY status
UNION
SELECT status, COUNT(*)
  FROM dba_ind_subpartitions
 GROUP BY status

重建索引

alter index pk_kc03 rebuild nologging;
or
alter index pk_kc03 rebuild