My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.