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 and later
Information in this document applies to any platform.


On Configurator Build 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. Oracle Configurator Developer Responsibility,
2. Concurrent Programs: Schedule
3. Enable the CZPURGE concurrent program
4. The log file shows that the program failed.




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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.