I'm to move a trigger from dev to prod. The problem is if I create the trigger, it will automatically fire because new data is coming into prod. How do I go about creating the trigger but in a disable form?
Printable View
I'm to move a trigger from dev to prod. The problem is if I create the trigger, it will automatically fire because new data is coming into prod. How do I go about creating the trigger but in a disable form?
Build your trigger and then immediatley disable it...
CREATE or REPLACE TRIGGER
...
...
...;
ALTER TRIGGERDISABLE;
Thanks for the information.
That's what I ended up doing.