Problem
You need a better understanding on how Oracle database triggers work with Oracle GoldenGate replication
Solution
By default in an Oracle database, triggers do fire only when a statement executed from a user process, and do not fire in case of Oracle-maintained processes, like Logical standby SQL Apply or Oracle Streams replication processes
The property can be changed by using the procedure:
DBMS_DDL.SET_TRIGGER_FIRING_PROPERTY
When set to FALSE, triggers will fire during replication, that is, the statements issued by Replicat processes
No comments:
Post a Comment