Skip to content

检查无效触发器

如有失效触发器可对其进行重编译或重建,使其恢复正常:

SQL> SELECT TRIG_NAME,TRIG_COND FROM DBA_TRIGGERS WHERE ENABLE='F';
SQL> ALTER TRIGGER triger_name RECOMPILE;