​ 分区索引状态

​ 分区索引状态 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行。 */

转载于:https://www.cnblogs.com/iyoume2008/p/7735301.html