TABLES WITHOUT INDEXES NOTES

 

Tables With No Indexes

TABLES WITHOUT INDEXES NOTES:

Owner - Owner of the table

Table Name - Name of the table

select  OWNER,
 TABLE_NAME
from 
(
select  OWNER, 
 TABLE_NAME 
from  dba_tables
minus
select  TABLE_OWNER, 
 TABLE_NAME 
from  dba_indexes
)
orasnap_noindex
where OWNER not in ('SYS','SYSTEM')
order  by OWNER,TABLE_NAME