I was wondering if anyone knows a bulletbroof way to find depenencies for views and functions within a database. I have tried using utlbtree but am not 100% sure on how to utilize it. Does anyone have any experience that could possibly help me out?
dunno if this helps, it shows Foreign Key references from/to Tables
set feed off
set pagesize 10000
break on owner on referenced_type on referenced_name on type skip 1
column datum new_value datum noprint
column owner format A10 heading 'Object|Owner'
column name format A24 heading 'Object|Name'
column type format A10 heading 'Object|Type'
column referenced_name format A22 heading 'Parent|Name'
column referenced_type format A10 heading 'Parent|Type'
ttitle center 'Dependencies to/from all Objects' skip 2
select to_char(sysdate, 'MM/DD/YY') datum,
where owner not in ('SYS','SYSTEM')
and referenced_type not in ('NON-EXISTENT')
order by 1,2,3,4,5,6;
is DBA_DEPENDENCIES what you're looking for? I think it's there in versions from 7.3.4 on, at least.
Click Here to Expand Forum to Full Width