Replicat Abends With ORA-29861 Domain Index Is Marked LOADING/FAILED
(Doc ID 2701108.1)
Last updated on AUGUST 17, 2020
Applies to:Oracle GoldenGate - Version 18.104.22.168.2 and later
Information in this document applies to any platform.
Replicat is abended with following errors:
2020-08-14 02:14:02 WARNING OGG-01004 Aborted grouped transaction on <SCHEMANAME>.<TABLENAME>, Database error 29861 (OCI Error ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE (status = 29861), SQL <INSERT /*+ RESTRICT_ALL_REF_CONS */ INTO "SCHEMANAME"."TABLENAME" ("COL1","COL2","COL3","COL4","COL5","COL6") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6)>).
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