Replicate Oracle creates table using VARCHAR (BYTE)

[IanM]

Hi, Fairly new to replicate.

I'm setting up replicate between two oracle Databases. Source is Non-Unicode and destination is Unicode (AL32UTF8).

Replicate is creating the tables on the destination, and is using the VARCHAR2 (10 BYTE) format.

Because source and destination use different number of BYTEs due to the codepage, I'm getting truncation on the destination. 

Can I somehow force Replicate to use VARCHAR2 (10 CHAR) to overcome this, or will I have to do this manually by script and set replicate to truncate on full load. 

I assume if I have to create destination tables by script, I cannot rely on Replicate to create the first unique index, and I will have to do that manually as well?

Thanks

[john_wang · Accepted solution]

Hello @IanM ,

You can add an internal parameter

charLengthSemantics

 in Target Oracle endpoint advanced tab, set its value to CHAR.

Let me know if you need any additional assistance.

Regards,

John.

[IanM]

Many thanks John. That has solved the problem.