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;
  • June 28, 2016 | 12 views
  • Comments