RE: Finding the cause of object invalidation

From: Jeremiah Wilton <jeremiah_at_ora-600.net>
Date: Sun, 27 Aug 2006 10:19:50 -0700
Message-ID: <00c901c6c9fd$0173c130$48013b0a@flbp7000a>

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?

--

http://www.freelists.org/webpage/oracle-l Received on Sun Aug 27 2006 - 12:19:50 CDT