Re: commit afer unable to extend rollback segment

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