Sunday, June 22, 2008

oracle object dependencies

SQL> select name,referenced_name,referenced_type from sys.dba_dependencies where owner='salary' and name='tablename';
==> inside schema 'jephe', which are the objects table 'tablename' depends on? List name,referenced_name,referenced_type


SQL> select name,type,referenced_type from sys.dba_dependencies where owner='C_UAT' and referenced_name='REPORT_MAP';
==> list which are the objects that refers to object 'REPORT_MAP'.

No comments: