Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Rollback segments
I am trying to do an UPDATE on half a million rows of data. I keep
getting the following error:
ORA-01562: failed to extend rollback segment number 2 ORA-01650: unable to extend rollback segment R01 by 5000 in tablespace RBS Is there some way that I can modify the segments (there are 4 besides SYSTEM) so that I can execute this command fully? I don't care if I don't have the option to rollback or not.
thanks
Kevin
Received on Fri Sep 18 1998 - 12:43:21 CDT