一、普通索引是否失效
select * from dba_indexes s where s.owner in (‘ISMP‘,‘BOSS‘,‘PAY‘,‘ACCOUNT‘,‘SETTLE‘,‘TEMP_DSF‘) and s.status!=‘VALID‘;
二、分区索引状态
select * from dba_ind_partitions l where l.index_owner in (‘ISMP‘,‘BOSS‘,‘PAY‘,‘ACCOUNT‘,‘SETTLE‘,‘TEMP_DSF‘) and l.status!=‘USABLE‘;
三、重建索引
rebuild online;
Oracle 查看index是否失效
标签：acl set ora 索引 ali account build ons art