Re: Create TABLE with 1 EXTENT ??

In article <3t1pnt$mj4_at_news.acns.nwu.edu>, dma956_at_lulu.acns.nwu.edu (Dave Mausner) says:
>
>In article <3spjj5$hot_at_warp10.smartlink.net>,
>IDSI <idsi_at_warp10.smartlink.net> wrote:
>>How do I create a table with only one extent so that it never trys to
>>grab another extent ?
>>
>>I am new to this game and find it very confusing !!!!!!
>>
>>Thanks in Anticipation
>>
>>New DBA
>
>
>You specify the anticipated table size using create table with the
>storage() clause: something like:
>create table x (columns...) storage(initial 10M maxextents 1);
>--
I would NOT set "MAXEXTENTS 1". Set MINEXTENTS 1 MAXEXTENTS 249. This way the object will be created with 1 initial extent but may grow to 249 ... many secondary extents _may_ be a longer term performance problem but at least you won't have to find out how hard the "max extents reached" wall is ;-)

Try to keep your object in fewer extents by setting initail to the size you think the table will grow to.

Regards
GAG

Gerry A. Gilchrist ( GAG )			ObjectWorks Inc. 
						800, 100-4th Avenue S.W.  
						Calgary, Alberta 
						Canada T2P 3N2 
Tel: (403)237-7333
E-Mail:	gag_at_objectworks.com	WWW: http://www.objectworks.com 
***************************************************************************************