If you are only using the table for temp migration, I would suggest making the inital extent big eough to hold all the data (100K in your example). Make next the same if you like (100k), and set pctincrease to 0
Originally posted by gbrabham
Here's a little script that you can run to "guesstimate" the size of the table.... That is assuming that you know the number of columns and the average row size and the number of rows in the table...
For next_extent ... determine how many rows fit in a block, how many more rows will be added to the table and go from there ...
If you're letting Oracle manage your extents, you shouldn't need to specify a STORAGE clause for your table, correct?