Re: discover cause of object invalidation
- From: Igor Neyman <igor.neyman@xxxxxxxxx>
- To: Chris.Stephens@xxxxxxx
- Date: Thu, 3 Jun 2010 15:11:45 -0400
If know the objects your package depends on, you could check LAST_DDL_TIME
in dba_objects for them and see if there is any correspondence with the
time, when your package gets invalidated.
Anyway, this is one of the possibilities.
Regards,
Igor Neyman
On Thu, Jun 3, 2010 at 2:46 PM, Stephens, Chris <Chris.Stephens@xxxxxxx>wrote:
> We have a package that is invalidated on a somewhat regular basis. I’m
> trying to figure out the cause of the invalidation. I can see what objects
> it depends on but I can’t find a way to actually determine what caused the
> invalidation.
>
>
>
> Does anyone know of a way to do this?
>
>
>
> Thanks for any help,
>
> Chris
>
> CONFIDENTIALITY NOTICE:
> This message is intended for the use of the individual or entity to which
> it is addressed and may contain information that is privileged, confidential
> and exempt from disclosure under applicable law. If the reader of this
> message is not the intended recipient or the employee or agent responsible
> for delivering this message to the intended recipient, you are hereby
> notified that any dissemination, distribution or copying of this
> communication is strictly prohibited. If you have received this
> communication in error, please notify us immediately by email reply.
>
>
>
Other related posts:
