Re: Create TABLE with 1 EXTENT ??

Mark Bluemel (markb_at_pyramid.com) wrote:
: Karl Penney (aa651_at_ccn.cs.dal.ca) wrote:
: : 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 !!!!!!
 

: : You estimate the size of a full table (with as many rows as you will
: : ever have), then create your table with 1 extent of that size. Hopefully
: : you have estimated correctly and your table segment will not grow.
 

: : The estimating stuff is in chapter 8 of the System Administration Guide.
 

: And you say "MAXEXTENTS 1" when creating the table ...

If you do this, then your table will never be able to extend if for some reason your estimates were wrong or your table grows bigger than you thought.

--
Karl Penney                           |~~~~~~|     _/^\_     |~~~~~~|
DMR Group, Halifax, NS                |      | _/\_\   /_/\_ |      |
aa651_at_cfn.cs.dal.ca                   |      | >___________< |      |
74203.673_at_compuserve.com              |______|       |       |______|