Distributed Query Returns Different Results on Consecutive Runs when no Changes Exist in the Base Tables.
Last updated on SEPTEMBER 15, 2008
Applies to:Oracle Server - Enterprise Edition - Version: 22.214.171.124 to 11.01
This problem can occur on any platform.
Distributed Queries can sometimes return different results in consecutive runs, even when the base tables have not changed during the query executions.
The problem can appear in normal queries, when using views, materialized views refresh or any other operations using distributed queries. They are all the result of the same cause.
This can appear as a bug at first look, but is actually the expected behavior.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms