Re: Question on create more space for rollback segment

All solutions are totally BULL!
First of all, bring all rollback segments OFFLINE except R01( i.e. R02, R03 R04 etc.) KEEP the rollback segments in other tablespaces intact. (especially SYSTEM) ALTER ROLLBACK SEGMENT R0x OFFLINE;

Then log off and log on again (only do this for 7.3.xx) for best results. Now execute your insert or delete statement. Your Rollback tablespace (usually named RBS or ROLLB) should be large enough thoug,h (20Mb is sufficient for most needs!)

/Jacob

kvsraju_at_my-dejanews.com schreef in artikel <790n7j$1cn$1_at_nnrp1.dejanews.com>...
> In article <36AE2AB2.9A0424B5_at_werum.de>,
> Kai Horstmann <horst_at_werum.de> wrote:
> > cw98_at_my-dejanews.com schrieb:
> > >
> > > Folks,
> > >
> > > I get the following error when attempting to run
> > > an update on an Oracle7 server:
> > >
> > > ERROR at line 1:
> > > ORA-01562: failed to extend rollback segment number 2
> > > ORA-01650: unable to extend rollback segment R01 by 1024
> > > in tablespace RBS
> > >
> > > My questions is:
> > >
> > > Do I need to create a data file that correspond to
> > > the new space that I am allocating to the rolback
> > > segment? How do I do that?
> > >
> >
> > Hi
> >
> > your error indicates, that your rollback segment itself runs out of
> > space, not your tablespace.
> > Check with select from DBA_ROLLBACK_SEGS what the MAXEXTENTS and the
> > INITIAL_EXTENT and the NEXT_EXTENT parameters are.
> > With these parameters you can compute the maximal size of that rollback
> > segment.
> >
> > If you need more space you may try
> > ALTER ROLLBACK SEGMENT yyy STORAGE (NEXT more_space );
> > or
> > ... STORAGE (MAXEXTENTS more_extents);
> > or even
> > ... STORAGE (MAXEXTENTS UNLIMITED);
> >
> > The more extents (typically maximal 121 or UNLIMITED) you allow the
more
> > fragmented your rollback segment will be.
> > On the other side, if you need this big size not too often, this may
> > be OK cause rollback segements can shrink, if they are reused and not
> > unnecessary space is wasted.
> >
> > Good luck
> > Kai
> >
>
> hai,
> The solution is
> ADD SPACE TO THE TABLESPACE WHICH IS HAVING THE ROLLBACK SEGMENT
> It will work perfectly
>
> kvsraju_at_usa.net
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
 

>
Received on Mon Feb 01 1999 - 10:24:29 CST