Re: commit afer unable to extend rollback segment

does the delete statement have a condition on it? if not, and you are trying to delete all rows in a table, use the truncate command.

if you are using conditions, you could add more conditions to reduce the amount of rows processed.

Sasha Ostojic wrote:
>
> 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.
>
> Thanks,
> .sasha
Received on Wed Oct 22 1997 - 00:00:00 CDT