global_index_clause

The following is the syntax for the global_index_clause in the CREATE INDEX statement. Parameters not already described in this section are described following the syntax.

GLOBAL PARTITION BY RANGE (column_list)
(PARTITION [partition_name] VALUES LESS THAN (value_list) 
  [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]
      ) ] )
PARTITION

Specifies the partition ( partition_name) for this index.

VALUES LESS THAN

Specifies the upper bound for the new partition. The value_list is a comma-separated, ordered list of literal values which must collate greater than the partition bound for the highest existing partition in the table.

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