Re: commit afer unable to extend rollback segment

No Sasha ,
once the Oracle server encounters an error , it will immediately rollback the entire transaction .

What I suggest for you to do is use the s "Set transaction use rollback
 segment BIGROLLBACKSEGMENTNAME"

to use the larger rollback segment in your DB for your transaction, or maybe do a pl/sql procedure to break the transaction into smaller pieces .

I hope this helps !

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 Tue Oct 21 1997 - 00:00:00 CDT