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
USERIDALIAS
parameter in the parameter file.
Default
None
Syntax
HAVEUDTWITHNCHAR