The ability to temporarily enable or disable a trigger is provided by ALTER TABLE, not by ALTER TRIGGER
, because ALTER TRIGGER
has no convenient way to express the option of enabling or disabling all of a table's triggers at once.
alter table tab_xxx enable trigger [ trigger_name
| ALL | USER ]