日期:2014-05-17  浏览次数:20737 次

能在本地数据库为db_link里的表建trigger不?或用什么方法可实现
rt

------解决方案--------------------
Statements inside a trigger can reference remote schema objects. However, pay special attention when calling remote procedures from within a local trigger. If a timestamp or signature mismatch is found during execution of the trigger, then the remote procedure is not run, and the trigger is invalidated.


------解决方案--------------------
可以通过dblink建trigger,但一旦网络有问题可能造成两边的数据都不能插入进去