Re: Rollbacksegments

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Mon, 27 May 2002 03:53:34 -0400
Message-ID: <acsolu$s5qg2$1@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 Mon May 27 2002 - 02:53:34 CDT