复制完成后运行过程(Run procedure after replication finish)

复制完成后运行过程(Run procedure after replication finish)

我有2个dbs并在它们之间使用复制来复制一个模式。 （Oracle Streams）

是否可以在远程数据库中添加新数据后添加一个表触发器或类似这样的东西（对每一行更好）？

我在更新和插入时尝试触发器 - 它们不会被触发。

I have 2 dbs and use replication between them to replicate one schema. (Oracle Streams)

Is it possible to add on one table trigger or smthing like this to be invoked after new data added in remote db (better for each row)?

I try triggers on update and insert - they are not fired.

最满意答案

根据您尝试实现的逻辑类型，您可能希望创建自定义应用处理程序或包含自定义操作的应用规则。 “ 高级规则概念”的“流概念和管理”手册中的章节可能是开始查看可用选项的好地方。

When we replicate tables between 2 dbs also we replicate triggers.

But apply process on dest db disable triggers on dest table.

To force trigger execution on dest db need to run such procedure:

BEGIN DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY('<trigger_owner>', 'trigger_name', FALSE); END;