INTEGRATED REPLICAT ABEND DUE TO OGG-00870 ERROR (Doc ID 2124502.1)

Last updated on JANUARY 14, 2017

Applies to:

Oracle GoldenGate - Version 11.2.0.0.0 to 12.2.0.1.0 [Release 11.2 to 12.2]
Information in this document applies to any platform.

Symptoms

 Integrated Replicate abends with below errors

2015-08-07 09:23:37 ERROR OGG-00870 Database error 4043 (ORA-04043:object "FACTURAS"."FACTURA_LINEA_VALORACION_FISCAL" does not exist
ORA-00972: identifier is too long
ORA-06512: at "SYS.DBMS_XSTREAM_GG_ADM", line 776
ORA-06512: at line 1 SQL DECLARE PRAGMA AUTONOMOUS_TRANSACTION; apply_nm VARCHAR(30) := :1; src VARCHAR(300) := :2; tgt VARCHAR(300) := :3; method_nm VARCHAR(30) := :4; err_num INTEGER := :5; retries INTEGER := :6; delay_cs INTEGER := :7;

BEGIN
dbms_xstream_gg_adm.set_reperror_handler( apply_name=>apply_nm,
source_object=>src, object=>tgt, error_number=>err_num, method=>method_nm,
max_retries=>retries, delay_csecs=>delay_cs);

END;).

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