Re: Set initial extent to half of its size

You can't modify the size of the initial extent. Only next (and pctincrease for the following extents) can be modified.

If you want to modify the initial extent you have to recreate the table.

--
Have a nice day
Michel

Dominik Schroeder <dschroeder_at_gei-aachen.de> a écrit dans le message : 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 - 04:00:09 CST