Re: Finding the cause of object invalidation

  • From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
  • To: nirmalya@xxxxxxx
  • Date: Sun, 27 Aug 2006 11:22:10 +0200

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@xxxxxxx> wrote:

How do I figure out the cause of objects (Procedure, Package, Trigger) became INVALID?

Any pointers will be greatly appreciated....
--
//www.freelists.org/webpage/oracle-l



Other related posts: