-
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
-
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
-
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
-
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
/
Jeff Hunter
-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|