RE: Rollback Segments Errors

When you do, make init=next
can't tell from sqlplus output shown

On Thu, 09 Nov 2000 10:20:31
 David Barbour wrote:
>Take the rollback segement offline, drop it, then recreate it.
>
>David A. Barbour
>Oracle DBA - ConnectSouth
>512-681-9438
>dbarbour_at_connectsouth.com
>
>
>-----Original Message-----
>Sent: Thursday, November 09, 2000 11:26 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Why cant I change the minextents?
>
>SVRMGR> alter rollback segment r05
> 2> storage (minextents 10);
>alter rollback segment r05
>*
>ORA-01570: MINEXTENTS must be no larger than the 4 extents currently
>allocated
>
>SVRMGR> select
>segment_name,tablespace_name,INITIAL_EXTENT,MIN_EXTENTS,MAX_EXTENTS
> 2> from dba_rollback_segs
> 3> where segment_name='R05';
>SEGMENT_NAME TABLESPACE_NAME INITIAL_EX MIN_EXTENT MAX_EXTENT
>------------------------------ ------------------------------ ----------
>---------- ----------
>R05 RBS 1048576
>3 1000
>
>
>Thanks in advance.
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Larry Taylor
> INET: ltaylor_at_iq.com
>
>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: ListGuru_at_fatcity.com (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: David Barbour
> INET: DBarbour_at_connectsouth.com
>
>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: ListGuru_at_fatcity.com (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).
>

Get FREE Email/Voicemail with 15MB at Lycos Communications at http://comm.lycos.com Received on Thu Nov 09 2000 - 12:36:58 CST