TRAILCHARSETASCII/COLCHARSET(PASSTHRU) Are Not Working In Initial Load Mode
(Doc ID 2825816.1)
Last updated on JULY 20, 2024
Applies to:
Oracle GoldenGate - Version 19.1.0.0.4 and laterInformation in this document applies to any platform.
Symptoms
User reported that TRAILCHARSETASCII/COLCHARSET(PASSTHRU) were not working with the Initial Load process.
++extract in Initial Load mode with COLCHARSET(PASSTHRU, COL0, COL1) + TRAILCHARSETASCII , these 2 columns are captured as ASCII which in this case was not correct...
Name: <db2_table> (TDR Index: 1)
After Image: Partition x0c s
0000 000a 0000 d4bf d565 ced1 2e44 0001 0006 0000 | .........e...D......
e702 f5fa 0002 0003 0000 5900 0300 0300 004e 0004 | ..........Y......N..
000a 0000 4142 3030 3439 3120 0005 000a 0000 0000 | ....AB00491 ........
0000 0011 dc5d 0006 0003 0000 5000 0700 0300 0020 | .....]......P......
Column 0 (x0000), Len 10 (x000a)
0000 d4bf d565 ced1 2e44 | .....e...D <===== COL0
Column 1 (x0001), Len 6 (x0006)
0000 e702 f5fa | ......
Column 2 (x0002), Len 3 (x0003) <===== COL1
0000 59 | ..Y
Column 3 (x0003), Len 3 (x0003)
0000 4e | ..N
Column 4 (x0004), Len 10 (x000a)
0000 4142 3030 3439 3120 | ..AB00491
Column 5 (x0005), Len 10 (x000a)
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 |
Cause |
Solution |