ORA-02291 parent key not found - Conflict resolution handle?
edited Apr 1, 2014 12:00PM in GoldenGate, Streams and Distributed Database (MOSC) 2 commentsAnswered
In bidirectional replication, oftenly i am seeing this parent key not found error. I think in replication, order of insert in parent table is not happen first and unfortunately we can't disable the foreign key .
ORA-02291: integrity constraint (HSS.FK9090) violated - parent key not found)
Tried with various options like DBOPTIONS DEFERREFCONST, DEFERAPPLYINTERVAL 30 SECS and also made a constraint defferable, still no use.
Also i checked with below CDR statements in replicat, but this piece of code can resolve only the data conflict issue not the order of data insertions.
MAP STT.TAX, TARGET STT.TAX,
COMPARECOLS (ON UPDATE ALL, ON DELETE ALL),
0