declare
resource_busy exception;
pragma exception_init(resource_busy,-54);
begin
loop
begin
execute immediate 'drop index OS_USER_SERVICE_IDX1 ';
exit;
exception
when resource_busy
then
null;
end;
end loop;
end;
resource_busy exception;
pragma exception_init(resource_busy,-54);
begin
loop
begin
execute immediate 'drop index OS_USER_SERVICE_IDX1 ';
exit;
exception
when resource_busy
then
null;
end;
end loop;
end;