Re: Create a table Storage Parameters

Er, I think you are getting a little confused...

The "PCT_INCREASE parameter to 1" should be for the TABLESPACE to force coalescing, not the tables and indexes. For tables (and indexes) set PCT_INCREASE to 0 if you want linear growth, and using 'power of 2 sized' extents to improve the coalescing. See the Oracle White Papers on space management (or the Advanced DBA Handbook, Oracle Press.)

Steve Phelan.

Vincent Birlouez wrote in message <34FBF438.7628F8C3_at_logica.com>...
>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