Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Question on create more space for rollback segment
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 Sat Jan 30 1999 - 22:46:44 CST