Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Set initial extent to half of its size

Re: Set initial extent to half of its size

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 03 Feb 2000 20:25:51 +0800
Message-ID: <389973CF.7D28@yahoo.com>


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...

--



Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Feb 03 2000 - 06:25:51 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US