
The ACDR feature of Oracle GoldenGate adds hidden columns to tables to resolve conflicts when the same row is updated by different databases using active replication.
GoldenGate can also create a “tombstone table,” which records interesting column values for deleted rows.
The Oracle Data Pump Import command-line mode TRANSFORM parameter enables you to alter object creation DDL for objects being imported. Data Pump can exclude the hidden columns and the tombstone tables by setting a new import transform parameter OMIT_ACDR_METADATA.
TRANSFORM = transform_name:value[:object_type]
OMIT_ACDR_METADATA:[Y | N]
The default value is N. When set to Y (true), Oracle Data Pump Import excludes invisible columns from importing replicated tables deletes tombstone tables, and deletes all the automatic conflict detection and resolution (ACDR) instance procedural actions.

Leave a comment