Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> commit afer unable to extend rollback segment
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 Fri Oct 17 1997 - 00:00:00 CDT
![]() |
![]() |