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.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.141.199.122