SQL Language (MOSC)

MOSC Banner

How to Find all table of a schema which doesnot have synonyms.

edited Nov 24, 2010 9:33PM in SQL Language (MOSC) 7 commentsAnswered
Dear all,

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center