To calculate the space required by a table, see the information about managing database files in the Oracle Database Administrator's Guide. Then use the
MINEXTENTS clause in the SQL
TABLE statement to allocate the required space.
Another approach is to size extents large enough so that extent allocation is infrequent.