--Build table
CREATE TABLE lm_t1 (ID number,name varchar2 (ten), Sex VARCHAR2 (10))
Partition by range (ID)
(
Partition P1 values less than (10),
Partition P2 values less than (20),
Partition PM values less than (MaxValue)
);
--Global partition index (only hash and range are supported)
Create INDEX G_IND_LM_T1 on LM_T1 (ID)
Global partition by range (ID)
(
Partition P1 values less than (10),
Partition P2 values less than (20),
Partition PM values less than (MaxValue)
Create INDEX gh_ind_lm_t1 on LM_T1 (name)
Global partition by hash (name)
Partitions 3;
--Local partition index
Create INDEX l_ind_lm_t1 on lm_t1 (sex)
Local (partition p1,partition p2,partition p3);--View information
SELECT * from User_indexes D where D.table_name=upper (' lm_t1 ');
SELECT * from User_part_indexes d where d.table_name = Upper (' lm_t1 ');
SELECT * from User_ind_partitions D where d.index_name in (' G_ind_lm_t1 ', ' l_ind_lm_t1 ', ' gh_ind_lm_t1 ')
Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.
Examples of global partitioned indexes and local indexes
