Hi,
We're running OGG integrated replicat (OGG ver. 12.2.0.1.161018 in DB 12.1.0.2.160719), and I have a question related to the following replicat message:
2016-11-28 xx:yy:zz WARNING OGG-02544 Unhandled error (ORA-26787: The row with key ("X") = (Y) does not exist in table Z.W
ORA-01403: no data found) while processing the record at SEQNO x, RBA y in Integrated mode. REPLICAT will retry in Direct mode.
The ORA-26787 / ORA-01403 errors are expected, so that's not the issue. These two errors are being handled as exceptions.
However, based on the message "REPLICAT will retry in Direct mode" I understand that OGG replicat retries to apply the DML statement. This is unnecessary in this case, and my question is how to skip this retry operation in order to save time? Is there a parameter to tell replicat to skip the retry?
Thank you in advance
Marie-Louise