Rollback segments
From: Kevin Kirkpatrick <kjk_at_hrb.com>
Date: 1998/09/18
Message-ID: <36029BB9.8A57D960_at_hrb.com>#1/1
Date: 1998/09/18
Message-ID: <36029BB9.8A57D960_at_hrb.com>#1/1
[Quoted] [Quoted] 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 - 00:00:00 CEST