rc <rc_at_spam.com> wrote in message news:<0f2ff0t6ai6aokq523q6i6bt4vsuq1f4en_at_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 !!
Worked fine for me. DB=8.1.6.3 on Unix HP.
Received on Mon Jul 19 2004 - 09:57:10 CDT
