Question - anyone have a script to generate chain of dependencies for an object?
From: Chris Taylor <christopherdtaylor1994_at_gmail.com>
Date: Tue, 20 Jun 2017 09:52:54 -0500
Message-ID: <CAP79kiQwu6HNBUGyZcDEXSMYUL9wNHRcbgzgumU4X+pPtdkmLA_at_mail.gmail.com>
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.
Date: Tue, 20 Jun 2017 09:52:54 -0500
Message-ID: <CAP79kiQwu6HNBUGyZcDEXSMYUL9wNHRcbgzgumU4X+pPtdkmLA_at_mail.gmail.com>
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-lReceived on Tue Jun 20 2017 - 16:52:54 CEST