My Oracle Support Banner

ORA-01555: snapshot too old: rollback segment number During Purge Configurator Tables (Doc ID 1593568.1)

Last updated on OCTOBER 01, 2024

Applies to:

Oracle Configurator - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On Configurator Build 11.5.10.25.45 version, Maintenance: CZPURGE

When running the CZPURGE Concurrent Program for the first time after 2 years of using Oracle Configurator, the following error message is found in the log file:

ORA-01555: snapshot too old: rollback segment number 47 with name "_SYSSMU47$" too small


The issue can be reproduced at will with the following steps:
1. Select the Oracle Configurator Developer Responsibility,
2. Navigate to: Concurrent Programs > Schedule
3. Enable the CZPURGE concurrent program
4. The log file shows that the program failed with the above error message shown.

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


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