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@xxxxxxxxxxx>
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@xxxxxxxxxxxxxxx> said:
> 
> 
> --
> http://www.freelists.org/webpage/oracle-l
> 
> 
--
http://www.freelists.org/webpage/oracle-l


Other related posts: