分区索引按分区重建脚本

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 ;