Veridata Compare Fails With ORA-8103: object no longer exists
Last updated on JULY 17, 2017
Applies to:Oracle GoldenGate Veridata - Version 188.8.131.52 and later
Information in this document applies to any platform.
***Checked for relevance on 01-Dec-2014***
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?
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