Operative

Displays whether the trigger is currently operative. An inoperative trigger is a trigger that is no longer available to be activated. You must drop an inoperative trigger and then recreate it.

Note: Dropping and recreating a trigger can affect the activation order if multiple triggers for the same triggering operation and activation time are defined for the same table.