1. Oracle GoldenGate Microservices Documentation
  2. Prepare
  3. Prepare Databases
  4. MySQL
  5. Database Configuration
  6. Prepare Tables for Processing
  7. Triggers and Cascade Constraints Considerations
  8. Triggers

Triggers

Disable triggers on the target tables, or alter them to ignore changes made by the Oracle GoldenGate database user. Oracle GoldenGate replicates DML that results from a trigger. If the same trigger gets activated on the target table, then it becomes redundant because of the replicated version, and the database returns an error.