| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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:
>
> 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
> >
> >
My doco reads
"If the initial extent becomes smaller than INITIAL, then INITIAL is adjusted to the new size"
Its time for someone to post an example... :-) --
"Some days you're the pigeon, and some days you're the statue." Received on Thu Feb 03 2000 - 06:28:16 CST
 |
 |