DECLARE
CURSOR c_name IS
SELECT index_name, partition_name
FROM user_ind_partitions
WHERE status = 'UNUSABLE';
v_sql VARCHAR2(200);
BEGIN
FOR i IN c_name LOOP
v_sql := 'alter index ' || i.index_name || ' rebuild partition ' ||
i.partition_name || ' online ';
dbms_output.put_line(v_sql);
EXECUTE IMMEDIATE v_sql;
END LOOP;
END ;
分区索引按分区重建脚本
最新推荐文章于 2022-10-15 16:47:18 发布