Re: ROLLBACK SEGMENTS: Some basic questions

From: Atif Ahmad Khan <aak2_at_Ra.MsState.Edu>
Date: 1997/01/18
Message-ID: <aak2.853638530@Isis.MsState.Edu>#1/1

aak2_at_Ra.MsState.Edu (Atif Ahmad Khan) writes:

>ERROR at line 1:
>ORA-01562: failed to extend rollback segment number 1
>ORA-01628: max # extents (100) reached for rollback segment R01

>I thought I had taken care of all my rollback segment blues when I created
>the following rollback segment :

>create public rollback segment r01 tablespace RBS
>storage (initial 500K NEXT 500K OPTIMAL 10M MINEXTENTS 15 MAXEXTENTS 100) ;

I actually went ahead and dropped that rollback segment and created 2 others r01 and r02 with 200 MAXEXTENTS and OPTIMAL set to 25M. But this time I got the following error, which is different from the previous one. I dont know the difference however. Any ideas ?

ORA-01562: failed to extend rollback segment number 2 ORA-01650: unable to extend rollback segment R02 by 250 in tablespace RBS

Thanks.

Atif Khan
aak2_at_ra.msstate.edu Received on Sat Jan 18 1997 - 00:00:00 CST