Re: Trigger Invalid State

From: Mark D Powell <>
Date: Wed, 18 Jun 2008 18:15:56 -0700 (PDT)
Message-ID: <>

On Jun 18, 8:49 pm, rzaleski <> wrote:
> What would cause a trigger to have an invalid state?  Do triggers
> become invalid if you alter a table (but do not add/drop any columns
> that trigger references)?  Do triggers become invalid if you add an
> index to a table?

For table triggers adding an index to a table referenced by the trigger has no effect on the trigger state. Alteringa table referenced by the trigger on the other hand is likely to require Oracle to re-compile the trigger to ensure the code is valid prior to 11g and Oracle's more advanced dependency tracking.

Check DBA_DEPENDENCIES before altering any table to see what dependent objects are going to be affected.

Loss of object privileges can cause a trigger to become INVALID when the trigger code references tables owned by a different user than the trigger owner.

HTH -- Mark D Powell -- Received on Wed Jun 18 2008 - 20:15:56 CDT

Original text of this message