IMPORTANT DEPENDENCIES QUESTION IN ORACLE.

[Lakshmi Jagarlapudi]

Hi Everybody,

I have been working in Oracle database for a while. I am actually looking
for an easy way to get a dependency tree. I know Oracle
provides us with the script "utldtree.sql",however I am not really succesful
in using it.

To be more clear, what I want is ,say if there is a package A, which access
package B, which access view V which in turn is based
on table T. Then I want in a tree like structure the above dependencies give
the package A as a parameter.

Please let me know if you have any soltution.

thanks in advance.

[Hans Forbrich]

Lakshmi Jagarlapudi wrote:

Hi Everybody,

I have been working in Oracle database for a while. I am actually looking
for an easy way to get a dependency tree. I know Oracle
provides us with the script "utldtree.sql",however I am not really succesful
in using it.

To be more clear, what I want is ,say if there is a package A, which access
package B, which access view V which in turn is based
on table T. Then I want in a tree like structure the above dependencies give
the package A as a parameter.

Please let me know if you have any soltution.

thanks in advance.

Someone just asked the same question over in
Comp.Databases.Oracle.Server newsgroup.

Instead of trying to get the answers here, and there, and everywhere
else - why don't we just keep looking there. After all, it seems like
this might be a server related question.

[Daniel Roy]

Take a look at the view DBA_DEPENDENCIES.

Daniel