Last updated on MAY 24, 2016
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 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
Million Knowledge Articles and hundreds of Community platforms