GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Update aborted by ORA-01403 Replicat Abend

user2877716Apr 13 2013 — edited Apr 18 2013

Hi all

I have GoldenGate (version 10.4 in source and 11.2 january build in target) replication setup for around 400 tables, one of them sometimes fails with ORA-01403 (Update operation) and I have to sync it manually. The strange thing is that this tabla has supplemental logging enabled in source and it has PK, two essential condition for replication to work well. The values are inserted using insert.... values (no insert append). I am 100% sure that no process or person modify the target data manually.

What can be the reasoning behind these ORA_01403 errors causing replicat to abend? I searched on MOS but found no explanation.

The exotic options I have used in my replicat are

BATCHSQL
ALLOWNOOPUPDATES
DBOPTIONS SUPPRESSTRIGGERS

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on May 16 2013

Added on Apr 13 2013

#goldengate

4 comments

597 views