Tuesday, February 14, 2012

View synomym object


select o1.owner,o1.object_name, o2.owner,o2.object_name
from PUBLIC_DEPENDENCY t, Dba_Objects o1, Dba_Objects o2
WHERE t.object_id=o1.object_id
AND t.referenced_object_id=o2.object_id
AND o1.object_name='SYNONYM' and o2.OWNER='SCHEMA';

No comments:

Post a Comment