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.
You will need to use other means like Oracle flashback_scn export to sync such table. See our Knowledgebase article # 125531 for details. Since multiple Post queues get created with hash partitioning, you will need to run reconcile on all Post queues involving the table. These queues will not route other tables so it is possible to use the procedure listed in article 125531.
There are many other ways to sync such tables like cold export/import during quiet times. It is just that repair cannot be used to sync such tables, nor can compare be used to ascertain if the target table is in sync.
