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'.
Sunday, June 22, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment