3,491
社区成员
发帖
与我相关
我的任务
分享
select * from user_part_tables;
select * from user_tab_partitions;
select * from user_tab_subpartitions;
select * from user_part_indexes;
select * from user_ind_partitions;
select * from user_ind_subpartitions;
select table_name,
partitioning_type type,
p.subpartitioning_type,
p.partition_count
from user_part_tables p;
select index_name,
partitioning_type type,
p.subpartitioning_type,
p.partition_count
from user_part_indexes p;
select tp.table_name, tp.high_value, tp.subpartition_count, tp.tablespace_name
from user_tab_partitions tp;
select ts.partition_name, ts.subpartition_name, ts.tablespace_name
from user_tab_subpartitions ts;
select tp.index_name, tp.high_value, tp.tablespace_name
from user_ind_partitions tp;