Shulou(Shulou.com)06/01 Report--

-check for corrupted indexes

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

-- rebuild the index

Alter index pk_kc03 rebuild nologging;oralter index pk_kc03 rebuild

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.