Re: Question on create more space for rollback segment

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 Received on Tue Jan 26 1999 - 14:50:58 CST