Re: Create TABLE with 1 EXTENT ??

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.

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