Table Not Synching Up In Target Due To ORA-13209:
(Doc ID 2250060.1)
Last updated on APRIL 04, 2017
Applies to:
Oracle GoldenGate - Version 12.2.0.1.0 and laterInformation in this document applies to any platform.
Goal
Extract was abending due to:
OCI Error ORA-29877: failed in the execution of the ODCIINDEXUPDATE routine
ORA-13209: internal error while reading SDO_INDEX_METADATA table
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 270 (status = 29877), SQL <UPDATE /*+ RESTRICT_ALL_REF_CONS */ "KBUSTDBA"."MPA_MERCHANT_CHECKIN" x SET x."LOCATION" = :a1 WHERE x."TID" = :b0>
Aborting transaction on /goldengate/traildata/CRI_FORWARD/cf beginning at seqno 2634 rba 381866717
error at seqno 2634 rba 381866947
Problem replicating KBUSTDBA.MPA_MERCHANT_CHECKIN to KBUSTDBA.MPA_MERCHANT_CHECKIN
Mapping problem with compressed update record (target format)...
*
TID = 106615412004856576
000000: 31 30 36 36 31 35 34 31 32 30 30 34 38 35 36 35 |1066154120048565|
000010: 37 36 |76 |
LOCATION = (UDT)
*
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |