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 18.104.22.168 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 22.214.171.124.
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