- partition table 查询
–查询分区表的属性(USER_PART_TABLES表)
select * from user_part_tables t where t.table_name=’ABC’;
–查询分区表的具体分区(USER_TAB_PARTITIONS表)
select * from user_tab_partitions p where p.table_name=’ABC’ order by p.partition_position;
- partition index 查询
–查询分区索引的属性(USER_PART_INDEXES表)
select index_name,table_name,partitioning_type,partition_count,locality from user_part_indexes;
–查询分区索引的具体分区 (USER_IND_PARTITIONS表)
select * from user_ind_partitions p where p.index_name=’IDX_ABC’ order by p.partition_position;