[PL/SQL] 인덱스가 없는 테이블 조회

select owner, table_name, tablespace_name, num_rows, last_analyzed
from dba_tables
where owner||table_name in
                      (select owner || table_name from dba_tables
                       minus
                       select table_owner || table_name from dba_indexes
                       )
  and owner = '<오라클 유저>'
order by num_rows desc;