Extract Abended With ERROR OGG-00665 OCI Error fetching udt lob data fragment (status = 1555-ORA-01555: snapshot too old: rollback segment number<number> with name "<name>" too small)

(Doc ID 2286462.1)

Last updated on JULY 13, 2017

Applies to:

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

Symptoms

On : 12.2.0.1.0 version, 1 - Oracle DB backend, Extract abended with below error:

2017-06-15 03:12:44 ERROR OGG-00665 OCI Error fetching udt lob data fragment (status = 1555-ORA-01555: snapshot too old: rollback segment number 26 with name "_SYSSMU26_2015373393$" too small),
SQL<SELECT x."Q_NAME",x."MSGID",x."CORRID",x."PRIORITY",x."STATE",x."DELAY",x."EXPIRATION",x."TIME_MANAGER_INFO",x."LOCAL_ORDER_NO",x."CHAIN_NO",x."CSCN",x."DSCN",x."ENQ_TIME",x."ENQ_UID",
x."ENQ_TID",x."DEQ_TIME",x."DEQ_UID",x."DEQ_TID",x."RETRY_COUNT",x."EXCEPTION_QSCHEMA",x."EXCEPTION_QUEUE",x."STEP_NO",x."RECIPIENT_KEY",x."DEQUEUE_MSGID",x."SENDER_NAME",x."SENDER_ADDRESS",x."SENDER_PROTOCOL",x."USER_DATA",x."USER_PROP" FROM "GLOGOWNER"."INTG_QUEUE" AS OF SCN :scn x WHERE ROWID = :rid>.



ERROR
-----------------------
OGG-00665

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