My Oracle Support Banner

"ORA-01555: snapshot too old: rollback segment..." Errors When Running Analytics Migration Script Upgrading From v8.5.x to v8.6.0 (Doc ID 2293663.1)

Last updated on MARCH 29, 2019

Applies to:

Oracle Knowledge - Version 8.6 and later
Information in this document applies to any platform.


When upgrading existing Analytics v8.5.x DB to the new OK v8.6.0, the Analytics migration script (Reporting_Build_8600.sql) failed due to out of temp space with following error:

ORA-01555: snapshot too old: rollback segment number with name "" too small
ORA-06512: at line 8
01555. 00000 - "snapshot too old: rollback segment number %s with name \"%s\" too small"
*Cause: rollback records needed by a reader for consistent read are
overwritten by other writers
*Action: If in Automatic Undo Management mode, increase undo_retention
setting. Otherwise, use larger rollback segments




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

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