INITIAL

The INITIAL parameter in the STORAGE clause determines how much space will be allocated to the first extent when an object is created. This parameter may be specified in bytes, kilobytes, or megabytes. For example, the following all specify the same amount of storage to be allocated to the INITIAL extent:

INITIAL 1048576
INITIAL 1024K
INITIAL 1M

The default value for INITIAL is the INITIAL value established in the DEFAULT STORAGE for the tablespace in which the object is being created.

Tip

Extent sizes should be specified as integer multiples of the Oracle blocksize; otherwise, the allocation is rounded up to the next Oracle block. For example, with a 2K (2048) blocksize, a request for INITIAL 4097 results in three Oracle blocks being allocated.

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.

Start your free trial