oracle小循环修改索引并发

for rr in (

select owner,index_name from dba_indexes where owner='PROD'and UNIQUENESS ='NONUNIQUE' and status='UNUSABLE' )

loop

v_sql := c'alter index '||rr.owner||'."'||rr.index_name||'" rebuild nologging parallel 4 online';

v_sql2 :='alter index '||rr.owner||'."'||rr.index_name||'" parallel 1';

dbms_output.put_line(rr.owner||'.'||rr.index_name);

execute immediate v_sql;

execute immediate v_sql2;

end loop;

end;