ORA-01555 Snapshot Too Old: Developer and DBA Notes
ORA-01555: snapshot too old usually means Oracle could not reconstruct the older version of data needed by a query because the required undo information was no longer available. Why it happens A long-running query needs older row versions while other sessions keep changing the same data. The undo tablespace is too small for the workload. … Read more