-
Title
Duplicate process when running COMPARE -
Description
In a horizontal partition environment, user run COMPARE statement agains one table, and in the COMPARE STATUS output shows up two lines for the same table
sp_ctrl (orarep03:2400)> compare scott.invoices
comparing 1 of 1 objects
compare started; job id 9
sp_ctrl (orarep03:2400)> compare status
Job ID : 9
PID : 31357
Host : orarep03.local
Started : 19-MAR-15 14:23:43
Job Type : Compare
Status : Processing - 0 objects completed
ID Tablename Status Time Total Rows %Comp Total Time
------ ------------------------------------ ---------- ---------- ---------- ----- ----------
1 "SCOTT"."INVOICES" WaitMarker 0:04 N/A 0:06
2 "SCOTT"."INVOICES" WaitMarker 0:04 N/A 0:06
-
Cause
Duplicated rotes on SHAREPLEX_PARTITION table -
Resolution
1 - Check your SHAREPLEX_PARTITION table, and look after duplicated rows for the partition route.
2 - Remove the additional row
3 - Reactivate the same config file