Monday 20 July 2009

Simple, disable oracle trigger

ALTER TRIGGER orders_before_insert DISABLE;

That’s it really…

1 comment:

Anonymous said...

I receive an error when running:
ALTER TRIGGER PRODDTA.F4201.DecimalsTriggerGetbyCOCRCD disable;

Error: ORA-00922:missing or invalid option (State:S1000, Native Code: 39A).

Could you help me?