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_at_gmail.com>:

> 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_at_hln.com> 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