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