My Oracle Support Banner

ORA-01555 FLASHBACK VERSIONS QUERIES VERSIONS BETWEEN SCN 0 AND MAXVALUE (Doc ID 2675130.1)

Last updated on JUNE 18, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 19.6.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Post upgrade to  19.6 flashback queries see:

 

The table  <schemas>.<table> has had no DML performed on it since before the table was enabled for flashback archive.

Getting ORA-01555 when issuing Flashback Versions queries (i.e.VERSIONS BETWEEN SCN 0 AND MAXVALUE) on tables that have a supporting Flashback Data Archive.

This is only happening in 19c database have had no such issue with this application, or similar ones, running 11.2, 12.1 or 12.2, for years.

The error may be raised on tables that actually have inserts/updates in the timeframe covered by the query, or on tables that have not had any inserts/updates in that timeframe.

Examination of trace files collected during these failures (provided) show that the error occurs during read of UNDO for the base table, not while trying to access the supporting SYS_FBA_xxx tables.

Repeated executions of the failing query may then succeed for a while, then later fail again.

The error is sporadic, not entirely consistent, but it is frequent.

 

Changes

None.

Cause

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
Symptoms
Changes
Cause
Solution
References


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