My Oracle Support Banner

Extract Writes Extra FieldComp/Update Records In Trail Due To Piece Wise Operations By Classic Replicat For LOB Data (Doc ID 2479703.1)

Last updated on JANUARY 13, 2022

Applies to:

Oracle GoldenGate - Version 12.3.0.1.3 and later
Information in this document applies to any platform.

Symptoms

Problem Summary
---------------------------------------------------
Replicat creating additional row in the target table in Cascading replication environment.

Problem Description
---------------------------------------------------
If the trail contains an INSERT followed by a LargeObject record for a table with a LOB column, classic replicat applies as INSERT followed by a piecewise LOB write instead of one INSERT statement. 

This causes INSERT+Update records in Trail by Extract, which is processing the transaction applied by classic replicat.

It will cause additional row in target table if replicat process such trail using INSERTALLRECORDS parameter.

Error Codes
---------------------------------------------------
No errors. It is logical issue.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.