Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Removing OPTIMAL from a rollback segment
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