Truncates
TRUNCATE statements can be supported as follows:
-
As part of the Oracle GoldenGate full DDL support, which supports
TRUNCATE TABLE,ALTER TABLE TRUNCATE PARTITION, and other DDL. This is controlled by the DDL parameter (see Enabling DDL Support.) -
As standalone
TRUNCATEsupport. This support enables you to replicateTRUNCATE TABLE, but no other DDL. TheGETTRUNCATESparameter controls the standaloneTRUNCATEfeature. For more information, see Parameters and Functions Reference for Oracle GoldenGate.
To avoid errors from duplicate operations, only one of these features can be active at the same time.