查找一张表索引大于5

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');