–检查损坏索引
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
