Rules for creating range-partitioned global indexes are similar - Oracle Indexes and Partitioned Tables

Discussion

• Nirja Shah   -Posted on 29 Sep 15
  - The PARTITION BY RANGE clause of the CREATE TABLE statement specifies that the table or index is to be range-partitioned.
  
  - The PARTITION clauses identify the individual partition ranges, and optional subclauses of a PARTITION clause can specify physical and other attributes specific to a partition segment.
  
  - If not overridden at the partition level, partitions inherit the attributes of their underlying table.
  
  - The rules for creating range-partitioned global indexes are similar to those for creating range-partitioned tables.
  
  - The following is an example of creating a range-partitioned global index on sales_month for the table created in the preceding example.
  
  - Each index partition is named but is stored in the default tablespace for the index.
  
  CREATE INDEX month_ix ON sales(sales_month)
  GLOBAL PARTITION BY RANGE(sales_month)
  (PARTITION pm1_ix VALUES LESS THAN (2)
  PARTITION pm2_ix VALUES LESS THAN (3)
  PARTITION pm3_ix VALUES LESS THAN (4)
  PARTITION pm4_ix VALUES LESS THAN (5)
  PARTITION pm5_ix VALUES LESS THAN (6)
  PARTITION pm6_ix VALUES LESS THAN (7)
  PARTITION pm7_ix VALUES LESS THAN (8)
  PARTITION pm8_ix VALUES LESS THAN (9)
  PARTITION pm9_ix VALUES LESS THAN (10)
  PARTITION pm10_ix VALUES LESS THAN (11)
  PARTITION pm11_ix VALUES LESS THAN (12)
  PARTITION pm12_ix VALUES LESS THAN (MAXVALUE));

➨ Post your comment / Share knowledge