当前位置: 代码迷 >> Oracle开发 >> 能在当地数据库为db_link里的表建trigger不?或用什么方法可实现
  详细解决方案

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

热度:172   发布时间:2016-04-24 08:03:07.0
能在本地数据库为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,但一旦网络有问题可能造成两边的数据都不能插入进去
  相关解决方案