Re: tables with no synonyms

I like:

select t.table_owner, t.table_name
from dba_synonyms s, dba_tables
where s.table_name = o.synonym_name(+) and o.synonym_name is null and
(various ownership issues here)

--
http://www.freelists.org/webpage/oracle-l