Re: rollbacks ??

Hi
you can use a plsql, after 100 rows are deleted you issue an explict commit statement.i hope this will solve ur prob.

the plsql can be as follows

declare
cnt number;
declare cursor c1 is select primary column of the table

cnt := 0;
loop
delete from table where column = cursor_fetch_value;

if cnt = 100 then
commit;
cnt := 0;
else
cnt := cnt + 1;
end if;
end loop

Regards
Sarvanan

> One way to get around this is to create some huge rollback segment for batch
> processing. You can specify the huge rollback segment in your batch to
> avoid overflow.
>
> David Ng
>
> Ed Lufker wrote in message <6l0uve$nah$1_at_sloth.swcp.com>...
> >Hi all:
> >
> >
> > Can anyone give me some tips on how to size my rollback segments
> >for both batch and OLTP. I was getting the following error when doing a
> >delete last night.
> >
> >
> >ORA-1628: max # extents 505 reached for rollback segment R05
> >Failure to extend rollback segment 6 because of 1628 condition
> >FULL status of rollback segment 6 cleared.
> >
> >thanks
> >eddie lufker
> >
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Sun Jun 14 1998 - 23:08:49 CDT