noindex.sql

rem This simple script lists all tables that do not have any indexes.

ttitle  'Report on all Tables Without Indexes'
select  owner, table_name 
  from  all_tables
MINUS
select  owner, table_name 
  from  all_indexes;