Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: ROLLBACK SEGMENTS: Some basic questions

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US