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?

On Jun 18, 8:49*pm, rzaleski <rzale...@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 --