"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 AUGUST 03, 2017

Applies to:

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

Symptoms

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

Cause

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 hundreds of Community platforms