数据导入时触发器的处理

导入数据时有可能触发数据库已存在的触发器，可以在导入时先disable触发器，等导入完成后再把触发器打开。

SQL>  select 'alter trigger '||trigger_name||' disable;' from user_triggers;


'ALTERTRIGGER'||TRIGGER_NAME||'DISABLE;'
-----------------------------------------------------
alter trigger LOGMNRGGC_TRIGGER disable;
alter trigger AW_TRUNC_TRG disable;
alter trigger AW_REN_TRG disable;
alter trigger AW_DROP_TRG disable;
alter trigger CDC_ALTER_CTABLE_BEFORE disable;
alter trigger CDC_CREATE_CTABLE_AFTER disable;
alter trigger CDC_CREATE_CTABLE_BEFORE disable;
alter trigger CDC_DROP_CTABLE_BEFORE disable;
alter trigger XDB_PI_TRIG disable;


9 rows selected.