select index_name, partition_name, statusfrom user_ind_partitionswhere status = 'UNUSABLE'union allselect index_name, '' as partition_name, statusfrom user_indexeswhere status = 'UNUSABLE';
本文共 246 字，大约阅读时间需要 1 分钟。
select index_name, partition_name, statusfrom user_ind_partitionswhere status = 'UNUSABLE'union allselect index_name, '' as partition_name, statusfrom user_indexeswhere status = 'UNUSABLE';
转载于:https://www.cnblogs.com/fubinhnust/p/9928872.html