Re: tables with no synonyms

  • From: "Thomas Day" <tomdaytwo@xxxxxxxxx>
  • To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx
  • Date: Thu, 8 Feb 2007 08:43:51 -0500

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)

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 02-2007