Hey,
I believe you may know about this already, but in case its something new to you: Yes, this is possible since 11g!
Prior to 11g, it was only possible to create triggers in the enabled state, and after creating to disable them. Since 11g they can be explicitly enabled or disabled at creation time using clause ENABLE or DISABLE. As per example:
CREATE OR REPLACE TRIGGER disabled_trigger BEFORE INSERT ON table_example FOR EACH ROW DISABLE BEGIN NULL; END; /
If didn’t know it yet. Np! You know it now! 😀
Cheers!
