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.

https://docs.oracle.com/en/database/oracle/oracle-database/23/sutil/oracle-datapump-import-utility.html#GUID-64FB67BD-EB67-4F50-A4D2-5D34518E6BDB

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.