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 TRUNCATE support. This support enables you to replicate TRUNCATE TABLE, but no other DDL. The GETTRUNCATES parameter controls the standalone TRUNCATE feature. For more information, see Reference for Oracle GoldenGate.

To avoid errors from duplicate operations, only one of these features can be active at the same time.