My Oracle Support Banner

OGG-06326 Extract encountered a snapshot-related error retrieving table xxxx.xxxx during initial load. OCI Error ORA-01555: snapshot too old: rollback segment number 6 with name "_SYSSMU6_2382701630$" too small (status = 1555). (Doc ID 2675385.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

Initial load extract is abending with the below error and the table has CLOB data type

2020-05-09 18:49:42 ERROR OGG-06326 Extract encountered a snapshot-related error retrieving table XXXX.XXXX during initial load. OCI Error ORA-01555: snapshot too old: rollback segment number 6
 with name "_SYSSMU6_2382701630$" too small (status = 1555).

2020-05-09 18:49:42 ERROR OGG-01668 PROCESS ABENDING.

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
Cause
Solution
References


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