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

Home -> Community -> Usenet -> c.d.o.server -> Re: Removing OPTIMAL from a rollback segment

Re: Removing OPTIMAL from a rollback segment

From: rc <rc_at_spam.com>
Date: Fri, 16 Jul 2004 08:55:50 +0100
Message-ID: <0f2ff0t6ai6aokq523q6i6bt4vsuq1f4en@4ax.com>


On 15 Jul 2004 09:14:55 -0700, gopahdoo_at_yahoo.com (GoPahDoo) wrote:

>"paddy_nyr" <mpprpp_at_yahoo.com> wrote in message news:<2lm06nFe28hvU1_at_uni-berlin.de>...
>> Can I do this with an 'alter' command or do I need to take the rollback
>> segment offline, drop and recreate?
>>
>> I'm using Oracle 8.1.7.4 on Solaris 8.
>>
>>
>> Thanks
>
>Try setting optimal to NULL.
>
>i.e.
> alter rollback segment <segment_name>
> storage (optimal null)
> /
>

The optimal cannot be set to null, it must be bigger than the initila extent size !! Received on Fri Jul 16 2004 - 02:55:50 CDT

Original text of this message

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