Json format in Kafka replication does not show all columns data for updates
说明
When replicating data from Oracle to Kafka in Json format, Updates does not display all column data.
原因
Updates by default on the redo log will only have the modified and the pre-image columns displayed in the update DML.
解决办法
Enable supplemental logging for all the columns to display all column data in the redo log. SharePlex will replicate all column data to the target by setting SP_OCT_REDUCED_KEY to 1 on Source and SP_OPX_REDUCED_KEY to 0 on Target(default values).
