Object Dependencies !
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Object Dependencies !

  1. #1
    Join Date
    Jun 2001
    Posts
    10
    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

  2. #2
    Join Date
    Mar 2001
    Posts
    188
    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

  3. #3
    Join Date
    Jun 2001
    Posts
    10
    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

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095

    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
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Jul 2000
    Posts
    296
    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
  •  



Click Here to Expand Forum to Full Width