use "alter rolback segment <name> storage (maxextents <value>));"
you should not use system rollback for application work. Read doco on how to create non-system rollback segments. Long -----Original Message----- Sent: Wednesday, 28 August 2002 8:43 PM To: Multiple recipients of list ORACLE-L Jonny Delmont wrote: > > Dear Gurus, > > Could you please help me out with this - I want to increase the > maxextents of below segment. > > TIA, > > SQL> select OWNER,SEGMENT_NAME,SEGMENT_TYPE,EXTENTS,MAX_EXTENTS > 2 from dba_segments > 3 where ((max_extents-extents)/max_extents)*100 <40 and max_extents > != 0 > 4 / > > OWNER SEGMENT_NAME SEGMENT_TYPE EXTENTS MAX_EXTENTS > ------ --------------- ------------------ ---------- ----------- > SYS SYSTEM ROLLBACK 505 505 > > SQL> connect sys > Enter password: > Connected. > SQL> alter ROLLBACK sys.system storage (maxextents 1024); > alter ROLLBACK sys.system storage (maxextents 1024) > * > ERROR at line 1: > ORA-01902: SEGMENT keyword expected > > TIA > > Jonny > a) RTF "SQL Reference" M. b) RTF "Concepts" M. Your SYSTEM rollback segments should not be big. In fact, I think that you should do b) before a). -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
