Re: Set initial extent to half of its size

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 - 06:42:37 CST