-
Title
Repair fails with Error: expected constraint col count=1 is NOT same as fetched constraint col count=0 when replicating from a table to a view -
Description
The following errors are observed in target compare log (*declt* log) as repair fails when source table is replicating to a view:
declt 2016-06-22 11:37:54.569581 43393 1 Error: expected constraint col count=1 is NOT same as fetched constraint col count=0
declt 2016-06-22 11:37:54.570025 43393 1 Oracle Error 1403: ORA-01403: no data found
declt 2016-06-22 11:37:54.570025 43393 1
declt 2016-06-22 11:37:54.658884 43393 1 Error ORA-1403 calling OCIBindByPos () in de_repair_insert (2928)
declt 2016-06-22 11:37:54.659101 43393 1 No further repairs will be applied
declt 2016-06-22 11:37:54.659181 43393 1 Error 1 calling de_repair_insert in de_compare_client (1498)
-
Cause
Repair tries tries to retrieve column_name from dba_cons_columns based on the view name but cannot find it as expected. -
Resolution
Workaround:
Use “onepass” option in repair. The syntax is:
sp_ctrl>repair owner.source_object to owner.target_object onepass