|
-
Nope,
I tried putting the commit inside the loop after the exit when command but still it is giving me the error
declare
cnt number := 0;
begin
select count(*) into cnt from test;
cnt := cnt/10000;
cnt := ceil(cnt);
for i in 1..cnt loop
loop
delete from test where rownum <=50 and region not in ('REGROLL','WWF','WWR','CON','REGWEST','
'CAN','LATAM','OWH','REGEAST','AFRME','ASPAC','EUR','OEH','OTH','NCI','WOUS','WOUSCON');
EXIT WHEN SQL%ROWCOUNT = 0;
commit;
end loop;
end loop;
end;
/
declare
*
ERROR at line 1:
ORA-01562: failed to extend rollback segment number 3
ORA-01562: failed to extend rollback segment number 3
ORA-06512: at line 9
Anurag
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|