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.
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
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 !
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#
connect by prior d_obj# = p_obj#
start with p_obj# = ( select object_id
where owner = upper('&objowner')
and OBJECT_NAME = upper('&objname')
and object_type = upper('&objtype'))) tb,
where o.object_id = tb.d_obj#
order by tb.rn
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.
Click Here to Expand Forum to Full Width