 | |
Trigger Invalid State
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Trigger Invalid State -
06-18-2008
, 07:49 PM
#2
| |||
| |||
|
|
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? |
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 --
#3
| |||
| |||
|
|
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? |
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 --
#4
| |||
| |||
|
|
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? |
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 --
#5
| |||
| |||
|
|
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? |
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 --
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.