Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rollbacksegments
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