DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2000


    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?

  2. #2
    Join Date
    Jun 2000
    Madrid, Spain
    dunno if this helps, it shows Foreign Key references from/to Tables

    spool obj_dependencies.lst
    set feed off
    set pagesize 10000
    ttitle off

    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,
    substr(owner,1,10) owner,
    substr(referenced_type,1,10) referenced_type,
    substr(referenced_name,1,22) referenced_name,
    substr(type,1,10) type,
    substr(name,1,24) name
    from dba_dependencies
    where owner not in ('SYS','SYSTEM')
    and referenced_type not in ('NON-EXISTENT')
    order by 1,2,3,4,5,6;

    spool off;

  3. #3
    Join Date
    Oct 2000
    Cambridge, MA (Boston)
    is DBA_DEPENDENCIES what you're looking for? I think it's there in versions from 7.3.4 on, at least.


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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.