Wrong Results or ORA-918 Errors From Distributed Queries When Stored Outlines Are In Use
Last updated on MAY 24, 2016
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":
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