You could look for all dependencies for the invalidated object in ALL_DEPENDENCIES, then see if any of those dependent objects have a recent LAST_DDL_TIME in ALL_OBJECTS. If you are auditing DDL, then look in DBA_AUDIT_TRAIL for what happened. Jeremiah Wilton ORA-600 Consulting http://www.ora-600.net -----Original Message----- From: Nirmalya Das 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? -- //www.freelists.org/webpage/oracle-l