Re: Create a table Storage Parameters

Ok with that, but may I advise you to set the PCT_INCREASE parameter to 1 instead of 0. By this way Oracle will automatically coalesce free spaces.

roy.klassen_at_compaq.com wrote:

> In article <34f29406.0_at_news.profinet.at>,
> "Joe" <josef.huber_at_ennstal.at> wrote:
> >
> > Hello all,
> >
> > Is it possible to override the default storage parameters when creating a
> > table or index ?
> >
> > Ciao,
> > Joe
> >
> > E-Mail: josef.huber_at_ennstal.at
> > Homepage: http://www.ennstal.at
> >
> >
> Joe:
>
> I recommend that you always override the default storage parameters.
>
> To do this use the storage clause in the create table command.
>
> eg. create table test
> (column1 number(1),
> column2 varchar2(3)
> )
> tablespace DATA01
> storage( INITIAL 100M <===== storage cluse
> NEXT 100M
> MINEXTENTS 1
> MAXEXTENTS 99
> PCTINCREASE 0 )
>
> Roy,
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Tue Mar 03 1998 - 00:00:00 CST