Table with LOBs goes out of sync when NCHAR_CHARACTERSET on source and target is different (84627)

Table with LOB datatype goes out of sync chronically when NCHAR_CHARACTERSET on source and target is different

NCHAR_CHARACTERSET on source and target is different and may affects LOBS

1. ON TARGET:

sp_ctrl> stop post

Sp_ctrl> set param SP_OPO_NCHAR_CHARACTERSET { source NCHAR_CHARACTERSET value}

2. Resync table.

NOTE: If resyncing using compare set the following parameters:

On source:

sp_ctrl> set param SP_DEQ_NCHAR_CHARACTERSET {target NCHAR_CHARACTERSET value)

sp_ctrl> set param SP_DEQ_NLS_LANG_SELECTOR 2

Sp_ctrl>compare table {statement}