"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