Re: IMPORTANT DEPENDENCIES QUESTION IN ORACLE.

From: Laly <lalystar_at_free.fr>
Date: Tue, 25 Nov 2003 06:26:06 +0100
Message-ID: <3fc2e7f1$0$28623$636a55ce@news.free.fr>

Hello,

You can have a look at SYS.DEPENDENCY$ i think it will help you, it contains object_id.

Laly.

"Lakshmi Jagarlapudi" <jlnarayana_at_comcast.net> a écrit dans le message de news: zyBwb.220907$mZ5.1688466_at_attbi_s54...
> 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.
>
>
>
>
Received on Mon Nov 24 2003 - 23:26:06 CST