查找一张表索引大于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');