goldengate 引數之GETTRUNCATES | IGNORETRUNCATES

GETTRUNCATES | IGNORETRUNCATES
Valid For
Extract and Replicat
Description
Use the GETTRUNCATESand IGNORETRUNCATES parameters to control whether or not
Oracle GoldenGate processes table truncate operations. By default, truncate operations
are not captured from the source or replicated to the target.
GETTRUNCATES and IGNORETRUNCATES are table-specific. One parameter remains in
effect for all subsequent TABLE or MAP statements, until the other parameter is
encountered.
In a coordinated Replicat configuration, truncates are always processed by the thread
that is responsible for barrier transactions.
預設的在僅僅開啟DML複製的情況下TRUNCATE是不被捕獲的，如果需要捕獲請時候引數，EXTRACT端和REPLICAT端
都需要開啟

3 Supported Databases
■ GETTRUNCATESand IGNORETRUNCATESare not supported for Teradata.
■ GETTRUNCATESand IGNORETRUNCATESare supported by Extract for Oracle and
Sybase.
■ GETTRUNCATESand IGNORETRUNCATESare supported by Replicat for Oracle, SQL
Server, Sybase, DB2 LUW, DB2 z/OS, MySQL, SQL/MX, and other ODBC targets
that support the TRUNCATEcommand.
本組引數僅僅支援ORACLE和SYBASE

3 Oracle Limitations
■ Oracle GoldenGate supports the Oracle TRUNCATE TABLE command, but not
TRUNCATE PARTITION. You can replicate TRUNCATE PARTITIONas part of the full
Oracle GoldenGate DDL replication support.
■ The database does not log truncates against an empty table, so those operations
are not captured by Oracle GoldenGate. The DDL support of Oracle GoldenGate
can be used for this purpose.
■ The database does not log truncates for empty partitions, so Oracle GoldenGate
cannot reliably process TRUNCATE TABLE when the table contains any empty
partitions. Do not use GETTRUNCATES on any partitioned table. Oracle GoldenGate
DDL support can be used to capture truncates on tables that might include empty
partitions.

本組引數僅僅支援在未開啟DDL複製的情況下需要TRUNCATE TABLE的情況，但是不支援TRUNCATE paration，
如果需要TRUNCATE PARATITION請開啟DDL複製
如果TUNCATE一個空表，在只支援DML的情況下是不捕獲的，如果需要捕獲請開啟DDL複製