SOS Need dependency report for migration to production
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SOS Need dependency report for migration to production

  1. #1
    Join Date
    Dec 2000
    Posts
    5

    Angry

    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
    Location
    Madrid, Spain
    Posts
    7,447
    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
    Location
    Cambridge, MA (Boston)
    Posts
    144
    is DBA_DEPENDENCIES what you're looking for? I think it's there in versions from 7.3.4 on, at least.

    D.

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