GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Golden Gate replicate - Source Table column CHAR, Target VARCHAR2

edited Mar 4, 2014 12:00PM in GoldenGate, Streams and Distributed Database (MOSC) 1 commentAnswered

Hello,

We have implemented GG across two DB on 11.2.0.4. The GG version is 12.1.2. There are tables having column data type as CHAR, while the data type defined in target is VARCHAR2.

The replicate is abending with 'NO Data Found' error, as it is filtering out the first 2 bytes from the key column value while updating. The key column value 2014223301 is read as 14223301.

Is it due to the way the CHAR and and VARCHAR are written to trail file? My understanding is for CHAR, 2 bytes are written before the ASCII value, while for VARCHAR, 4 bytes are written followed by ASCII value

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center