​ 分区索引状态 - Oracle-fans - 博客园

​

分区索引状态

set pagesize 1000

set linesize 1000

col partition_name for a15

col partitioning_type for a25

col index_name for a15

select t2.locality, t2.partitioning_type, t1.index_name, t1.partition_name, t1.status, t1.tablespace_name from user_ind_partitions t1, user_part_indexes t2 where t1.index_name in ('C31$FPDM_FPHM', 'C31$JSSJ')a and t1.index_name = t2.index_name order by index_name, partition_name;

/* LOCALI PARTITIONING_TYPE INDEX_NAME PARTITION_NAME STATUS TABLESPACE_NAME

------ ------------------------- --------------- --------------- -------- ------------------------------     

GLOBAL HASH     C31$FPDM_FPHM     PART1801     USABLE    LVSKSK_I_M_1801

GLOBAL HASH     C31$FPDM_FPHM     PART1802     USABLE    LVSKSK_I_M_1802

GLOBAL HASH     C31$FPDM_FPHM     PART1803     USABLE    LVSKSK_I_M_1803

GLOBAL HASH     C31$FPDM_FPHM     PART1804     USABLE    LVSKSK_I_M_1804

GLOBAL HASH     C31$FPDM_FPHM     PART1805     USABLE    LVSKSK_I_M_1805

GLOBAL HASH     C31$FPDM_FPHM     SYS_P72     USABLE    LVSKSK_T_GY

LOCAL RANGE     C31$JSSJ       P_201609     USABLE    LVSKSK_I_JS_P

LOCAL RANGE     C31$JSSJ       P_201801    USABLE    LVSKSK_I_M_1801

LOCAL RANGE     C31$JSSJ       P_201802     USABLE    LVSKSK_I_M_1802

LOCAL RANGE     C31$JSSJ       P_201803     USABLE    LVSKSK_I_M_1803

LOCAL RANGE     C31$JSSJ       P_201804     USABLE    LVSKSK_I_M_1804

LOCAL RANGE     C31$JSSJ       P_201805     USABLE    LVSKSK_I_M_1805 已选择12行。 */