Oracle Database Administration: The Essential Refe

segment_attrib_clause

The following is the syntax for the segment_attrib_clause in the CREATE TABLE statement:

[PCTFREE integer]
   [PCTUSED integer]
   [INITRANS integer]
   [MAXTRANS integer]
   [TABLESPACE tablespace_name] 
   [LOGGING | NOLOGGING]  
   [STORAGE (
      [INITIAL integer[K | M] ]
      [MINEXTENTS integer]
      [MAXEXTENTS {integer | UNLIMITED} ]
      [PCTINCREASE integer]
      [FREELISTS integer]
      [FREELIST GROUPS integer]
      ) ]

PCTFREE

Specifies the percentage of space to be reserved in each data block for future updates to rows contained in that block. Valid values are - 99, and the default value is 10.

PCTUSED

Specifies the minimum percentage of space that will be maintained as used in each data block. Valid values are 1- 99, and the default value is 40.

INITRANS

Specifies the initial number of transaction entries allocated to each block.

MAXTRANS

Specifies the maximum number of transaction entries allocated to each block.

TABLESPACE

Specifies the tablespace for the table.

LOGGING

Specifies that the operation is to be logged to the redo logs.

NOLOGGING

Specifies that nothing is to be written to the redo logs for this operation.

STORAGE

Specifies the physical characteristics of the table as follows:

INITIAL

Specifies the size of the first extent for this table in bytes, kilobytes, or megabytes. If this value is not a multiple of the database blocksize, it will be rounded up to a multiple of the database blocksize.

NEXT

Specifies the size of the next extent in bytes, kilobytes, or megabytes. If this value is not a multiple of the ...