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
sp_ctrl> stop post
Sp_ctrl> set param SP_OPO_NCHAR_CHARACTERSET { source NCHAR_CHARACTERSET value}
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}
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy