The following is the syntax for the segment_attrib_clause in the CREATE TABLE statement:
[PCTFREEinteger
] [PCTUSEDinteger
] [INITRANSinteger
] [MAXTRANSinteger
] [TABLESPACEtablespace_name
] [LOGGING | NOLOGGING] [STORAGE ( [INITIALinteger
[K | M] ] [MINEXTENTSinteger
] [MAXEXTENTS {integer
| UNLIMITED} ] [PCTINCREASEinteger
] [FREELISTSinteger
] [FREELIST GROUPSinteger
] ) ]
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.
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.
Specifies the initial number of transaction entries allocated to each block.
Specifies the maximum number of transaction entries allocated to each block.
Specifies the tablespace for the table.
Specifies that the operation is to be logged to the redo logs.
Specifies that nothing is to be written to the redo logs for this operation.
Specifies the physical characteristics of the table as follows:
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.
Specifies the size of the next extent 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.
Specifies the number of extents to be allocated when this table is created. The minimum and default value is 1.
Specifies the maximum number of extents that may be allocated for this table. The default will vary according to the database blocksize. Specify UNLIMITED for unlimited expansion.
Specifies the percentage by which each extent will grow over the previous extent. The default is 50, which means that each extent will be one-and-one-half times larger than the previous extent.
Specifies the number of free lists contained in each freelist group in this table. The default is 1 and the maximum depends on the database blocksize.
Specifies the number of groups of free lists for this table. The default is 1. This parameter should be used only with the Parallel Server option running in parallel mode.