Replicat fails with ORA-2291 - Integrity Constraint violated error
Experts
I ran into a stituation where my replicat failed with ORA-2291 error. Upon investigation, I found that the replicat was trying to insert the child record before the parent record. We are using ONLY ONE replicat and so there is no scenario of child table in one replicat and the parent in the other. Has anyone come across this situation? What was the resolution? Under what circumstances does Goldengate attempt to insert a child record before the parent.
The scenario above has Sybase as the Source and Oracle as the target.
Thanks
I ran into a stituation where my replicat failed with ORA-2291 error. Upon investigation, I found that the replicat was trying to insert the child record before the parent record. We are using ONLY ONE replicat and so there is no scenario of child table in one replicat and the parent in the other. Has anyone come across this situation? What was the resolution? Under what circumstances does Goldengate attempt to insert a child record before the parent.
The scenario above has Sybase as the Source and Oracle as the target.
Thanks
0