Re: Trigger Invalid State
Date: Wed, 18 Jun 2008 18:15:56 -0700 (PDT)
Message-ID: <0d4d0587-5f3a-4d7a-9f76-3fa3a475ac13@f63g2000hsf.googlegroups.com>
On Jun 18, 8:49 pm, rzaleski <rzale..._at_gmail.com> 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