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 later
Information 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms