My Oracle Support Banner

Flashback Query Returns Wrong Results On ALL_SOURCE Or DBA_SOURCE Tables in PDB Database (Doc ID 2665323.1)

Last updated on AUGUST 03, 2020

Applies to:

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


When using flash back query it works on a custom user table, but when querying dba_source or all_source it returns the current data not matter what timestamp or SCN is used.

The problem happens in CDB/PDB Multitenant environment

The problem does not happen in non-CDB environment.

Also the issue does not happen for normal tables (user tables) even in Multitenant environment. So the problem exists for SQLs using dictionary views in PDB.

There isn't any restriction for flashback queries in CDB/PDB after restriction was lifted from

In CDB, the plan goes for base tables than the extended data link.


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

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