Delete no Oracle

[eversonpizaParticipante]

Anderson,

Para fazer o commit a cada 1000 registros vc teria que fazer algo assim:


declare
cursor crTabela
select t.rowid rid
from tabela t
where

vCommit number := 0;

begin
for c in crTabela loop
delete from tabela where rowid = c.rid;
vCommit := vCommi + 1;
if vCommit >= 1000 then
commit;
vCommit := 0;
end if;
end loop;
commit;
end;
/
[/code]