1.86 HAVEUDTWITHNCHAR
Valid For
Replicat (Oracle only)
Description
Use the HAVEUDTWITHNCHAR
parameter when the source data contains user-defined types that have an NCHAR
, NVARCHAR2
, or NCLOB
attribute. When this data is encountered in the trail, HAVEUDTWITHNCHAR
causes Replicat to connect to the Oracle target in AL32UTF8
, which is required when a user-defined data type contains one of those attributes.
HAVEUDTWITHNCHAR
is not required if the character set of the target is AL32UTF8
. However, it is required if only NLS_LANG
is set to AL32UTF8
on the target. By default Replicat ignores NLS_LANG
and connects to an Oracle database in the native character set of the database. Replicat uses the OCIString
object of the Oracle Call Interface, which does not support NCHAR
, NVARCHAR2
, or NCLOB
attributes, so Replicat must bind them as CHAR
. Connecting to the target in AL32UTF8
prevents data loss in this situation.
HAVEUDTWITHNCHAR
must be specified before the USERID
or USERIDALIAS
parameter in the parameter file.
Default
None
Syntax
HAVEUDTWITHNCHAR
Parent topic: Oracle GoldenGate Parameters