--检查损坏索引

SELECTstatus,COUNT(*)FROMdba_indexesGROUPBYstatusUNIONSELECTstatus,COUNT(*)FROMdba_ind_partitionsGROUPBYstatusUNIONSELECTstatus,COUNT(*)FROMdba_ind_subpartitionsGROUPBYstatus


--重建索引

alterindexpk_kc03rebuildnologging;oralterindexpk_kc03rebuild