Hi all,
I have a scenario whereby I have to run a series of tables of updates. There are numerous triggers on the table which I want to disable before the updates and then enable them back after.
I know I could use ALTER table_name DISABLE ALL TRIGGERS; do my updates and then run ALTER table_name ENABLE ALL TRIGGERS.
The problem with this is that some of the triggers might become disabled before the time where I need to run this and if I run the above statements, the triggers that have correctly been disabled become enabled after.
Is there a way that I can get around this?
Thanks