Object Dependencies !

[sandya]

Question:
I need to find out the dependent objects for any given object, say a column or a table or a procedure. Is there any oracle package or any API for this. Or are system tables the only way which will give me these object dependencies.

Regards,
sandya

[tomate]

if you use the following tools as sql-navigator4.0 or toad you see the depends. So there must be a way to show but i don't now it. If you have one of this tools in your company then you can see the depends on an easy way

Regards
Thomas

[sandya]

Thanx Thomas !

You are right, toad, sql navigator etc have this feature but then i don't want this from any tool since I need to use this for a development in my project.

so a tool usage is not of much use.

thanks once again !

sandya

[marist89]


set pages 50
col dependant_object for a60
col parent_object for a60
col dependency_tree for a60
set linesize 132
set verify off

accept objowner prompt 'Object Owner: '
accept objname prompt 'Object Name: '
accept objtype prompt 'Object Type: '

select lpad(' ',2*(lv -1)) || o.owner || '.' || o.object_name || ' (' || lower(o.object_type) || ')' dependency_tree, o.status
from (select rownum rn, level lv, d_obj#, p_obj#, d_owner#
from sys.dependency$
connect by prior d_obj# = p_obj#
start with p_obj# = ( select object_id
from dba_objects
where owner = upper('&objowner')
and OBJECT_NAME = upper('&objname')
and object_type = upper('&objtype'))) tb,
dba_objects o
where o.object_id = tb.d_obj#
order by tb.rn
/


[akkerend]

You can use DEPTREE, procedure deptree_fill and view ideptree. Run script utldtree as sys and read description in the script. With the procedure you fill a temporary table and with the view you can list dependencies.