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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.117.188.64