You can defer the creation of segments when creating a partitioned table until the first row is inserted into a partition. Subsequently, when the first row is inserted, segments are created for the base table partition, LOB columns, all global indexes, and local index partitions. Deferred segment creation can be controlled by the following:
DEFERRED_SEGMENT_CREATION initialization parameter to
FALSE in the initialization parameter file.
Setting the initialization parameter
FALSE with the
SYSTEM SQL statements.
Specifying the keywords
DEFERRED with the partition clause when issuing the
TABLE SQL statement.
You can force the creation of segments for an existing created partition with the
EXTENT SQL statement. This statement allocates one extent more than the initial number of extents specified during the
Serializable transactions do not work with deferred segment creation. Inserting data into an empty table with no segment created, or into a partition of an interval partitioned table that does not have a segment yet, can cause an error.
Oracle Database Reference for more information about the
DEFERRED_SEGMENT_CREATION initialization parameter
Oracle Database SQL Language Reference for more information about the
SYSTEM SQL statements
Oracle Database SQL Language Reference for more information about the keywords
DEFERRED of the
TABLE SQL statement