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)

References:

tables with no synonyms
From: Joe Smith

RE: tables with no synonyms
From: Mercadante, Thomas F \(LABOR\)

Other related posts:

Browse oracle-l