全域分區索引和本地索引樣本，全域索引樣本

全域分區索引和本地索引樣本，全域索引樣本
--建表
create table lm_t1(id number,name varchar2(10),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)
);
--全域分區索引(只支援hash和range)
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;
--本地分區索引
create index l_ind_lm_t1 on lm_t1(sex)
local(partition p1,partition p2,partition p3);--查看資訊
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')

著作權聲明：本文為博主原創文章，未經博主允許不得轉載。