Prev: Can't Find localhost
Next: Conditional Union ?
From: rzaleski on 18 Jun 2008 20:49
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?
From: Mark D Powell on 18 Jun 2008 21:15
On Jun 18, 8:49 pm, rzaleski <rzale...(a)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 --



 | 
Pages: 1
Prev: Can't Find localhost
Next: Conditional Union ?