分区表 分区索引对应关系

select   t3.table_name tab_name,    t3.partition_name tab_part_name,t2.locality  ind_locality,t1.index_name ind_name,t1.partition_name ind_part_name,t1.status ind_part_stat,t1.tablespace_name tbs_name
from user_ind_partitions t1, user_part_indexes t2  ,user_tab_partitions t3
where t1.index_name in ('SK_DEVICE_RECOVER_LOCAL') and t1.index_name=t2.index_name  and t2.table_name=t3.table_name and t1.partition_position = t3.partition_position
order by t1.index_name,t3.partition_name;