DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Tuesday, June 28, 2016

How to find the dependencies of schema

SELECT DECODE(referenced_type, 'NON-EXISTENT', '.....', referenced_type) Type
, referenced_owner,referenced_name Object, name referenced_by, owner, type,
' Referenced Link: ' || DECODE(referenced_link_name, null, 'none', referenced_link_name) r_link
FROM dba_dependencies
WHERE owner = upper('&schema')
ORDER BY 1,2,3;

No comments: