My Oracle Support Banner

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

Last updated on JANUARY 30, 2022

Applies to:

Oracle GoldenGate Veridata - Version 3.0.0.10 and later
Information in this document applies to any platform.

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("XXX_XXX_CD"), "XXX_XXX_VAL", "PASS_XXX_IND", "OFFER_XXX_ID", "MIS_XXX_ID", TO_CHAR("CREATEDATE", 'yyyy-MM-DD:hh24:mi:ss.FF6'), TO_CHAR("XXXX_NBR") from "<SCHEMA>"."DIAGONSTIC_INFO" x WHERE substr(id,47,1) between '!' and '4'> )
           

How can we correct this?

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution


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