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

Oracle索引状态查询与索引重建
强烈推介IDEA2020.2破解激活,IntelliJ IDEA 注册码,2020.2 IDEA 激活码
--检查损坏索引
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

 

本文来源huayang183,由架构君转载发布,观点不代表Java架构师必看的立场,转载请标明来源出处:https://javajgs.com/archives/18616

发表评论