My Oracle Support Banner

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

Last updated on JUNE 20, 2018

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:

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

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Oracle Configurator Developer Responsibility,
2. Concurrent Programs: Schedule
3. Enable the CZPURGE concurrent program
4. The log file shows that the program failed.

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!

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