Is it possible to define an Apply Error Handler that will remove a Logical Change Record from the tr
I have a problem that I have solved with version 10.2.0.3 and, in a different way, with version 11.2.0.2. Both solutions are kludgy, but do the job. I'm seeking to understand if there is simpler solution available, so that I may throw away the duct tape.
The Scenario:
Suppose you have 2-way bidirectional Streams replication configured between databases A and B. On database A, you have a transaction T that updates one row in each of three tables FOO, BAR and BAZ. Suppose that the FOO table is special in some way, and for reasons that are out of our control, the FOO table can sometimes be in an inconsistent state between databases A and B. Let's suppose that there are no records at all in FOO at database B. Normally, this situation would result in an apply error for the apply process on database B. The apply