Re: commit afer unable to extend rollback segment

If creating a bigger rollback segment is not an option, just put a where clause into the delete statement and commit regularly.

DELETE FROM my_table
where rownum < 1000;
commit;

and run it as many times as needed.

Danilo Gimenez wrote:

> Hi, Sasha.
>
> Sasha Ostojic <sasha_at_UltimateTech.com> escreveu no artigo
> <628jpd$r8b$1_at_news-sj-3.cisco.com>...
> > If I do "DELETE FROM my_table", and it eventually comes back with an
 error
> > saying "unable to extend rollback segment", is it OK to do a COMMIT?
 Will
> > the COMMIT purge any of the records that made it into the rollback
 segment
> > before it filled up? Or am I asking for trouble if I do this?
> >
> > I would prefere to do this rather than extend the rollback segment
 because
> > it is a one-time thing.
>
> Well, it all depends on how many SQL statements had run before COMMITing.
> If it is just one statement, OK, never mind. But if you have two or more
> statements before the COMMIT, then all data manipulations made by them will
> be written, except for the last statement (that one which caused the
> error). This situation may be not desirable, I don't know what is this
> "one-time thing".
> --
>
> DANILO GIMENEZ
> danilog_at_mandic.com.br
> Sao Paulo - SP - Brasil

--
Lembit Loo
Senior Consultant

Oracle Corporation

Disclaimer: all opinions expressed here are my own and do not necessarily
represent those of Oracle Corporation.