Compare/Repair does not work correctly. "Compare" showed out of sync but "compare with repair" showed in sync.
OR
Compare core dumps or Compare shows false out of sync when table is in sync.
There are three known problems:
1) Repair does not work when the key column(s) are NCHAR or NVARCHAR2.
2) When there are more than 5 NCHAR/NVARCHAR2 columns, Compare SIGSEGV due to incorrect memory allocation.
3) When NCHAR or NVARCHAR2 is key column. Compare may report false OOS rows due to the key comparison was strcmp that got confused by the null characters within the NCHAR/NVARCHAR2 strings.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center