NEXT

The NEXT parameter in the STORAGE clause determines how much space will be allocated for the second and subsequent extents allocated for an object. The NEXT parameter is specified in the same way as the INITIAL parameter. Although this parameter may be set to a specific value, that value may be modified dynamically if the PCTINCREASE parameter is set to a non-zero value. The default value for NEXT is the NEXT 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.