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 FEBRUARY 21, 2020
Applies to:
Oracle GoldenGate - Version 11.2.0.0.0 and laterInformation 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 "<schema name>"."<queue table>" AS OF SCN :scn x WHERE ROWID = :rid>.
ERROR
-----------------------
OGG-00665
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 |