How to Find all table of a schema which doesnot have synonyms.
I want to list all the tables of a schema doenot have synonyms.
i uesd the below script but it list all the tables
select count(*) from dba_tables t left outer join synonyms s
on t.owner = s.creator
and t.table_name = s.tname
and s.creator ='schema'
where t.owner ='schema'
and s.creator is null