OGG Classic Extract missing columns data in trail file for UPDATE statement
(Doc ID 2430869.1)
Last updated on JUNE 05, 2019
Applies to:Oracle GoldenGate - Version 184.108.40.206.0 to 12.3 Beta [Release 12.1 to 12.3]
Information in this document applies to any platform.
Classic GoldenGate replication between Oracle 220.127.116.11 database and Oracle 18.104.22.168 database. An UPDATE is applied to a row in the source database;
however the trail file does not contain all of the columns that were updated. Running log miner on the source database archive log shows that the sql_redo
contains all of the columns that were updated.
The update is to table schema.table_name and the column that is missing from the trail file is column_name. It should be set from "SUCCESS" to "NULL".
Logminer shows this correctly but the after image in logdump does not contain
this column (Column 46).
The version of GoldenGate is 22.214.171.124.170221
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document