When configuring truncate operation replication, you don't need the DDL replication enabled but need to consider the followings:
- In general (except for the DB2 z/OS capture), you need to make sure that GETTRUNCATES is included in both extract and replicat parameter files to replicat truncate operations because Oracle GoldenGate by default ignores truncation operations in all the processes.
- In an active-active replication, you can only replicate truncate operation in one-direction.
- You can't include a table for both GETTRUNCATES and DDL operation. Or you will get the "OGG-00506: Both GETTRUNCATES and DDL replication are enabled." error.
- Oracle GoldenGate 12.2 Documentation, 9.2.1 TRUNCATES
- Oracle GoldenGate 12.2 Documentation, OGG-00506: Both GETTRUNCATES and DDL replication are enabled