How to achieve synchronization of Chinese table names i…

Oracle GoldenGate can synchronize Chinese table names by using either a Double Byte Character Set (DBCS) or Unicode character set.

1. Use double-byte character set (DBCS):
2. Create a table in Oracle database that supports DBCS, such as using the NVARCHAR2 data type to store Chinese data.
3. Make sure to set the “USENLSCHARSET” parameter to a DBCS character set in the GoldenGate configuration file.
4. Set up the GoldenGate extract and replicate processes to ensure proper handling of DBCS character sets.
5. In the GoldenGate configuration file, define the tables to be synchronized using the correct table and column names.
6. Use the Unicode character set:
7. Create a table in Oracle database that supports Unicode by using NCHAR or NVARCHAR2 data types to store Chinese data.
8. Make sure the “USENLSCHARSET” parameter is set to the Unicode character set in the GoldenGate configuration file.
9. Configure GoldenGate’s extraction and replication processes to ensure proper handling of Unicode character sets.
10. In the GoldenGate configuration file, use the correct table and column names to define the tables that need to be synchronized.

Please ensure that the configuration file of GoldenGate is consistent with the character set setting of the database, whether it is using DBCS or Unicode, to guarantee proper synchronization and handling of Chinese table names.