Replicate Chinese Characters AMERICAN_AMERICA.ZHS16GBK to target charset AL32UTF8, Oracle to Oracle, 11.1 and before 11.2 (Doc ID 1469735.1)

APPLIES TO:

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

GOAL

How to replicate from Source Database: Oracle 10.2.0.4 charset AMERICAN_AMERICA.ZHS16GBK
to Target Database: Oracle 10.2.0.4 charset AMERICAN_AMERICA.AL32UTF8
 

SOLUTION

In the extract,
setenv NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
BEFORE the userid parameter.

This will cause extract to write the extended character set into the extract trail.

In the replicat
setenv NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
BEFORE the userid parameter
This will cause the replicat to know the data it is reading is in AMERICAN_AMERICA.ZHS16GBK format.

相关问题：

https://bbs.csdn.net/topics/398482978