Re: Finding the cause of object invalidation

I think my problem explanation was not clear:

Let's say, the objects (Procedure, Package, Trigger) were all VALID to begin
with. Now because of some creation/deletion of objects the previously VALID
objects became INVALID.
My question is how do I figure out which database action caused the previously
VALID objects became INVALID?

Quoting Stefan Knecht <knecht.stefan@xxxxxxxxx>:

If you try and compile them (alter procedure/package/trigger compile) -
check user_errors or dba_errors view for the cause of the failed compile.

Stefan

On 8/26/06, Nirmalya Das <nirmalya@xxxxxxx> wrote: 

How do I figure out the cause of objects (Procedure, Package, Trigger)
became
INVALID?

Any pointers will be greatly appreciated....
--
http://www.freelists.org/webpage/oracle-l





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


Other related posts: