Query on Filtering
Hi,
We are trying to filter some rows for a table but that results in replicat failing. The extract prm looks like the foll.:
table user.testtab, where (deptid=10);
table user.*;
But replicat fails with ora-1403. I think the above results in dml for testtab getting extracted twice (and hence getting applied twice on target). And probably the second dml fails on target side because it is referring to the new/changed value in the where clause. Is the understanding correct? If yes, is there a way out?
Thanks