From: Vincent Birlouez <birlouezv@logica.com>
Subject: Re: Create a table Storage Parameters
Date: 1998/03/03
Message-ID: <34FBF438.7628F8C3@logica.com>#1/1
Content-Transfer-Encoding: 7bit
References: <34f29406.0@news.profinet.at> <6cvr6n$qso$1@nnrp1.dejanews.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Organization: Logica UK Ltd.
Newsgroups: comp.databases.oracle.server



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@compaq.com wrote:

> In article <34f29406.0@news.profinet.at>,
>   "Joe" <josef.huber@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@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