Re: Set initial extent to half of its size

I'm afraid i'm not agree with you, follows an abstract of the Oracle alter table documentation:

<quote>
When the high water mark is less than the size of INITIAL or MINEXTENTS, then all unused space above MINEXTENTS is freed. </quote>

It seems to me that means you cannot deallocated below the INITIAL.

--
Have a nice day
Michel

Jaap W. van Dijk <j.w.vandijk_at_hetnet.nl> a écrit dans le message : #dpkQQkb$GA.284_at_net003s...
> This is only possible if the High Water Mark of the table is below half the
> inital extent, because you can never shrink below the HWM.
> If this is the case you can shrink the initial extent with
>
> ALTER TABLE <tablename> DEALLOCATE UNUSED KEEP <half the size of the
> intitial extent minus HWM)
>
> You have to check your next extent specification, if I'm not mistaken it
> will be resized to the last extent (back to front) removed.
>
> Jaap.
>
> Dominik Schroeder heeft geschreven in bericht
> <38995060.2C603A79_at_gei-aachen.de>...
> >Hi!
> >
> >For a number of tables I need to set the initial extent to half of its
> >current size. Since I'd like to do it automatically, I wonder if I can
> >do it (w/o PL/SQL...if possible).
> >
> >The statements' functionality ought to be like:
> >
> >alter table xxx storage ( initial select 0.5*initial_extent
> > from user_tables
> > where table_name='xxx'
> > );
> >
> >Best regards,
> >
> >Dominik Schröder
>
>
Received on Thu Feb 03 2000 - 08:42:21 CST