代码改变世界

【分区表】分区表分区索引重建

2023-02-06 16:03  明朝散发  阅读(87)  评论(0)    收藏  举报

SELECT 'alter index '||t2.owner||'.'||t1.INDEX_NAME||' rebuild partition '||t1.PARTITION_NAME||' online;',
t1.STATUS
FROM dba_ind_partitions t1, dba_indexes t2
where t1.index_name = t2.index_name
AND t1.STATUS = 'UNUSABLE' ;

SELECT 'alter index '||t1.index_owner||'.'||t1.INDEX_NAME||' rebuild partition '||t1.PARTITION_NAME||' online;',
t1.STATUS
FROM dba_ind_partitions t1
where t1.STATUS = 'UNUSABLE' ;