oracle如何查看全局索引和分区索引

create table t_ta(
c1 int,c2 varchar2(16),c3 varchar2(64),c4 int,
constraint pk_ta primary key (c1)
)
partition by range(c1)(
partition p1 values less than (10000),
partition p2 values less than (20000),
partition p3 values less than (30000),
partition p4 values less than (maxvalue)
);

-- 创建全局索引

create index idx_ta_c4 on t_ta(c4) global 
partition by range(c4)(
partition ip1 values less than(10000),
partition ip2 values less than(20000),
partition ip3 values less than(maxvalue)
);

-- 创建本地索引

create index idx_ta_c2 on t_ta(c2) local (partition p1,partition p2,partition p3,partition p4);

-- DBA查看索引分区

select * from dba_ind_partitions  where index_owner='DW'

-- 查看索引分区类型

select * from dba_part_indexes  where owner='DW'

-- USER查看索引分区类型

select * from user_part_indexes;
其中locality字段是表示是局部的还是全局索引。

LOCAL
GLOBAL