Oracle トリガーを一時的に無効化

今の状態を確認する

SELECT t.OWNER,t.TRIGGER_NAME,t.TRIGGER_TYPE,t.STATUS
FROM DBA_TRIGGERS t
where 1=1
and t.TRIGGER_NAME = 'TEST_DDL_TRIG'
and t.OWNER = 'SOONI'
order by t.TRIGGER_NAME
;

SQL*Plus用

OWNER      TRIGGER_NAME             TRIGGER_TYPE   STATUS
---------- ------------------------ -------------- ------------
SOONI      TEST_DDL_TRIG            BEFORE EVENT   DISABLED

SQL>

SQL*Plus用

set lin 300
set pages 100
COLUMN OWNER  FORMAT A10
COLUMN TRIGGER_NAME FORMAT A24
COLUMN TRIGGER_TYPE   FORMAT A14
COLUMN STATUS  FORMAT A12

一時的に無効化

ALTER TRIGGER TEST_DDL_TRIG DISABLE
;

有効化

ALTER TRIGGER TEST_DDL_TRIG ENABLE
;