Oracle Database Administration: The Essential Refe

index_organization_clause

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

[segment_attrib_clause]
[PCTTHRESHOLD integer] [INCLUDING column] OVERFLOW [segment_attrib_clause]

PCTTHRESHOLD

Specifies the maximum percent of an index block that any one row can use. Larger rows are forced into the OVERFLOW area. Allowable values are between and 50.

INCLUDING

Specifies the column after which the row is split when forced into the OVERFLOW area. The column must be the last column in the primary key or any column after the primary key.

OVERFLOW

Specifies the storage attributes of the OVERFLOW area.