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@(protected):


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