Thursday, April 25, 2024

Oracle GoldenGate 21c -- How Triggers Fired during Replication


You need a better understanding on how Oracle database triggers work with Oracle GoldenGate replication


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:


When set to FALSE, triggers will fire during replication, that is, the statements issued by Replicat processes

No comments: