Re: Trigger Invalid State

On Jun 18, 8:49=A0pm, rzaleski <rzale...@[EMAIL PROTECTED]
> wrote:
> What would cause a trigger to have an invalid state? =A0Do triggers
> become invalid if you alter a table (but do not add/drop any columns
> that trigger references)? =A0Do 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 --