Return
-
Title
The compare or repair errors out with Cannot compare horizontally partitioned by HASH table -
Description
The following errors are observed when running compare on a table involved in horizontal partitioning with hash:
sp_ctrl (alvsupu15:5438)> compare sha90.table1a
Cannot compare horizontally partitioned by HASH table "SHA90"."TABLE1A"
The whole table can be done using the force option, which may cause out-of-sync conditions
comparing 0 of 1 objects
1 object(s) contain errors
No objects to compare; no job started
Similar errors are also observed with repair.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.