Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: (invalid) dependencies management

Re: (invalid) dependencies management

From: GovindanK <gkatteri_at_fastmail.fm>
Date: Mon, 16 Jul 2007 00:12:32 -0700
Message-Id: <1184569952.26378.1200325069@webmail.messagingengine.com>


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
Received on Mon Jul 16 2007 - 02:12:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US