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]

Re: IMPORTANT DEPENDENCIES QUESTION IN ORACLE.

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]

Re: IMPORTANT DEPENDENCIES QUESTION IN ORACLE.

Take a look at the view DBA_DEPENDENCIE S.

Daniel