トリガーを全部無効化するPL/SQL
declare s dba_triggers.trigger_name%type; cursor c is select trigger_name from dba_triggers where table_name='&tablename'; begin open c; loop fetch c into s; exit when c%notfound; dbms_output.put_line(s); execute immediate 'alter trigger ' || s || ' disable'; end loop; close c; end; /