Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

ORA-29921

ancillary operator not supported with set view query block

Cause

The ancillary operator matched to a primary operator was outside a UNION ALL view query block while the primary operator was contained in one of the UNION ALL branches.


Action

Define the UNION ALL view query block to contain both the primary and ancillary operators, so that the operators are contained by the query block in the UNION ALL branch, rather than in the query block outside of the view.