Re: (invalid) dependencies management

A correction to my earlier post. After altering / ddl of the object , the dependent objs will would have become invalid and this will be reflected in either the last_ddl or timestamp columns.

HTH
GovindanK

On Sun, 15 Jul 2007 23:04:32 -0700, "GovindanK" <gkatteri_at_fastmail.fm> said:
> Hi Cos
>
> Few others have given their views. I have my own doubts about the
> user_dependencies etc views. The best way would be to take a list of
> invalid objs before and objs that have been invalidated after ddl change
> etc. If what i have observed is correct the timestamp column in
> user_objects should give you an idea of those objects that are
> "dependent".
>
> HTH
> GovindanK
>
>
> On Wed, 11 Jul 2007 10:06:45 -0700 (PDT), "Cosmin Ioan"
> <cosmini_at_bridge-tech.com> said:
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

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