Compare result shows the date column is out of sync, but the table is actually in sync. (4322236)

Compare result shows the date column is out of sync, but the table is actually in sync.

Different database character sets are used on the Source and Target, especially between multi-byte character set and single-byte character set.

WORKAROUND

When the character sets are different for the Source and Target databases, set the following parameters on the Source Server before running Compare/Repair operation.

sp_ctrl> set param SP_DEQ_CHARACTERSET xxxxx
(----xxxxx value from target NLS_CHARACTERSET )
sp_ctrl> set param SP_DEQ_NCHAR_CHARACTERSET xxxxxx
(--- xxxxxx value from target NLS_NCHAR_CHARACTERSET)
sp_ctrl> set param SP_DEQ_NLS_LANG_SELECTOR 2

To find out the Target database's character set, run the following query on the Target:

select * from nls_database_parameters;


STATUS

Waiting for fix in a future release of Shareplex for Oracle.

5.1.6.573
source 8.1.7.4/source is big endian
Target 9.2.0.5/target is little endian
Linux Target.