–建表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’)
版权声明：本文为博主原创文章，，未经博主允许不得转载。
也许不是自己该去发挥的地方，还是让自己到最适合自己战斗的方面去吧!勇敢的接受自己的失败，
