"ORA-01555: snapshot too old: rollback segment..." Errors When Running Analytics Migration Script Upgrading From v8.5.x to v8.6.0
Last updated on AUGUST 03, 2017
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms