Veridata Compare Fails With ORA-8103: object no longer exists (Doc ID 1506527.1)

Last updated on JULY 17, 2017

Applies to:

Oracle GoldenGate Veridata - Version 3.0.0.10 and later
Information in this document applies to any platform.
***Checked for relevance on 01-Dec-2014***

Symptoms

 Veridata compare fails with:

Error from target RHS. (Agent replied with error code Database query failed: 'ORA-08103: object no longer exists' SQL<select "ID", TO_CHAR("FAIL_RESN_CD"), "FAIL_RESN_VAL", "PASS_FAIL_IND", "OFFER_ID", "MIS_ID", TO_CHAR("CREATEDATE", 'yyyy-MM-DD:hh24:mi:ss.FF6'), TO_CHAR("OFFER_NBR") from "SGAPPOWNER"."DIAGONSTIC_INFO" x WHERE substr(id,47,1) between '!' and '4'> )

How can we correct this?

Cause

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