Wrong Results or ORA-918 Errors From Distributed Queries When Stored Outlines Are In Use
(Doc ID 1457100.1)
Last updated on JUNE 15, 2021
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
- A distributed query is producing wrong results.
- The query references the same table or view on the same database more than once.
- Stored Outlines are either being created or used.
- In the example:
Instead of producing the correct number of rows, this query might result in no rows returned at all.
Becasue of the view definition, the query effectively refers to table "t@remote" twice using the same alias, "t_vw":
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