oracle禁用和启用所有触发器

    技术2022-07-21  78

    直接执行下面脚本便可禁用所有触发器(触发器暂时失效)。将disable改为enable为启用(触发器恢复)

    declare v_sql varchar2(100); v_table_name varchar2(100); v_ref sys_refcursor; begin for v_ref in (select object_name from user_objects where object_type = 'TRIGGER') loop v_sql := 'alter trigger ' || v_ref.object_name || ' disable'; --将disable改为enable为启用 execute immediate v_sql; dbms_output.put_line(v_sql); end loop; exception when others then dbms_output.put_line(SQLCODE || ' ' || SQLERRM); end;

     

    Processed: 0.009, SQL: 10