MINEXTENTS

The MINEXTENTS parameter in the STORAGE clause determines how many storage extents will be allocated to the object at the time of initial creation. Typically, this parameter is set to 1, but if it is set to a value greater than 1, the second and subsequent extents will use the NEXT parameter and will be subject to dynamic modification if PCTINCREASE is set to a non-zero value. The default value for MINEXTENTS is the MINEXTENTS value established in the DEFAULT STORAGE for the tablespace in which the object is being created.

Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.