The following is the syntax for the local_index_clause in the CREATE INDEX statement. For an explanation of the parameters, refer to the descriptions earlier in this section.
LOCAL ( [PARTITION [partition_name
] [TABLESPACEtablespace_name
] [LOGGING | NOLOGGING] [INITRANSinteger
] [MAXTRANSinteger
] [STORAGE ( [INITIALinteger
[K | M] ] [MINEXTENTSinteger
] [MAXEXTENTS {integer
| UNLIMITED} ] [PCTINCREASEinteger
] [FREELISTSinteger
] [FREELIST GROUPSinteger
] ) ] ] )