Characters Are Replaced, Truncated Or Appended After Replicating With Golden Gate
Last updated on JULY 17, 2017
Applies to:Oracle GoldenGate - Version 188.8.131.52.6 and later
Information in this document applies to any platform.
for a table with column: NOT NULL VARCHAR2(30), replicat has parameter:
BATCHSQL BATCHERRORMODE BATCHESPERQUEUE 100, OPSPERBATCH 2000
after replicating to target, certain CHR(0) are added at the end of the column value.
SQL> select '__' ||<Column>|| '__', dump(KUNNR, 1016)
from <table> where <Column> like '%'||CHR(0);
Typ=1 Len=5 CharacterSet=UTF8: 20,0,0,0,0
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms