Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Set initial extent to half of its size
Michel Cadot wrote:
>
> 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
Doesn't "deallocate unused" do this...
--
"Some days you're the pigeon, and some days you're the statue." Received on Thu Feb 03 2000 - 06:25:51 CST
![]() |
![]() |