local_index_clause

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]
      ) ]
 ] )

Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial