在业务部间断下创建索引
时间：2010-09-20 来源：hxl
declare
resource_busy exception;
pragma exception_init (resource_busy,-54);
begin
loop
begin
execute immediate 'Alter index IDX_TB_TEST2_N1 noparallel';
exit;
exception
when resource_busy then
dbms_lock.sleep(1);
end;
end loop;
end;
resource_busy exception;
pragma exception_init (resource_busy,-54);
begin
loop
begin
execute immediate 'Alter index IDX_TB_TEST2_N1 noparallel';
exit;
exception
when resource_busy then
dbms_lock.sleep(1);
end;
end loop;
end;
相关阅读 更多 +
