From: "Steve Phelan" Subject: Re: Create a table Storage Parameters Date: 1998/03/03 Message-ID: <888935782.10497.0.nnrp-02.c2de712e@news.demon.co.uk>#1/1 References: <34f29406.0@news.profinet.at> <6cvr6n$qso$1@nnrp1.dejanews.com> <34FBF438.7628F8C3@logica.com> X-NNTP-Posting-Host: pmcgettigan.demon.co.uk [194.222.113.46] X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3 Newsgroups: comp.databases.oracle.server 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@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@compaq.com wrote: > >> In article <34f29406.0@news.profinet.at>, >> "Joe" 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 > > >