3zecisi3 ... DBA experiences
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment