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] 
  [TABLESPACE tablespace_name]
  [LOGGING | NOLOGGING]
  [INITRANS integer]
  [MAXTRANS integer]
  [STORAGE (
      [INITIAL integer[K | M] ]
      [MINEXTENTS integer]
      [MAXEXTENTS {integer | UNLIMITED} ]
      [PCTINCREASE integer]
      [FREELISTS integer]
      [FREELIST GROUPS integer]
      ) ]
 ] )