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 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

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 12.1.0.2.

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

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