Oracle数据库插入是触发器失效

Oracle数据库插入是触发器失效，此情况如下解决：

1.检查触发器的状态；SELECT trigger_name, status FROM user_triggers WHERE trigger_name = 'YOUR_TRIGGER_NAME';

2.检查表的序列配置表；select *   from  mas_seq_config_info ci where ci.table_name='MAS_MESSAGE_PUSH_INFO';

3.检查触发器开关表select * from  mas_tr_switch  ci where ci.trigger_name='TR_BI_MAM_PRODUCT_UPGRADES';

4.创建表、表的序列号的同义词：CREATE PUBLIC SYNONYM SEQ_MAM_TEST_USER_GROUP_PK
FOR MASDATA.SEQ_MAM_TEST_USER_GROUP_PK;

5.检查触发器的语法

masdata.MAM_PRODUCT_UPGRADES 少了属主；

end MASTRIG.TR_BI_MAM_PRODUCT_UPGRADES; 多了属主

触发器的开头要有触发器、表的属主，结尾不需要