Re: Rollbacksegments

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 29 May 2002 07:09:03 +1000
Message-ID: <ad0roa$a1i$1@lust.ihug.co.nz>

What????????

Of course, if this was truly an automatic undo segment issue, our original poster wouldn't have been able to issue a 'create rollback segment' statement at all.

So I think we can sum up this particular contribution as 'close, but no banana'.

Regards
HJR "Mladen Gogala" <mgogala_at_adelphia.net> wrote in message news:acsolu$s5qg2$1_at_ID-82084.news.dfncis.de...
> On Sun, 26 May 2002 19:04:51 -0400, Mechthild Marten wrote:
>
> > Thanks for your answer.
> > What I mean is this.
> > Oracle accepts the following sql-statements without an error message:
> >
> > create rollback segment test storage (initial 1M, next 1M, minextents 4)
> > alter rollback segment test shrink to 1M
> >
> > What happened with the initial parameters.
>
> Nothing special. Oracle is trying to improve automatic undo segment
> management and has introduced some "features" in the process. Quirks like
> that can be expected but can easily be overcome by using LMT and large
> enough extents.
> --
> Mladen Gogala
> Za Feral Spremni!
Received on Tue May 28 2002 - 16:09:03 CDT