Re: Question - anyone have a script to generate chain of dependencies for an object?

Are you looking for something derived from the Oracle-supplied utldtree.sql? (That is found in $ORACLE_HOME/rdbms/admin)

/Hans
> I was trying to write a script using DBA_DEPENDENCIES to track down a
> chain of dependencies for a TYPE that was dropped and recreated but
> I'm having a difficult time building it.
>
> So, instead of recreating a wheel, does anyone have a good
> DBA_DEPENDENCIES script that will generate a tree view of dependencies
> down from an object? Where you specify the name of the object, and
> see something like:
>
> OBJECT=<object_name that is changed>
> - Dependency Level 1
> - objectA
> - objectB
> ---- Dependency Level 2
> -----objectB1
> -----objectB2
> ----------- Dependency Level 3
> ------------objectB2s1
> ------------objectB2s2
>
>

--
http://www.freelists.org/webpage/oracle-l