Re: Rollback segments

I think I found a way around it. I went in and created another datafile for my table space. I then created a rollback segment for the tablespace that was slightly smaller than the datafile. Next I did a SET TRANSACTION USE ROLLBACK SEGMENT ........ and then executed my UPDATE. It is taking forever but that is a good sign! aghhh!! YES!!! it just finished. all half million rows were updated. I guess this proves that it work. This is my first time running into this particular problem. Thanks anyways... I normally post on here when I run into problems, because I am not sure how long it will take to solve them myself, but almost everytime I am able to solve it within 15 minutes or so...

Kevin Kirkpatrick wrote:

> 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 - 13:37:41 CDT