select b.owner, b.table_name, index_name,cnt, UNIQUENESS
from all_indexes
inner join (select owner, table_name, count(*) cnt
from all_indexes
group by owner, table_name
having count(*) >= 5) B
on (all_indexes.owner = B.owner and
all_indexes.table_name = b.table_name)
where B.owner in ('owner_name');
查找一张表索引大于5
最新推荐文章于 2023-08-22 23:51:11 发布