Oracle® Database 8i | 9i | 10g | 11g | 12c | 18c | 19c Error Codes

Information for Database Error Code ORA-29921: Ancillary operator not supported with set view query block
Oracle® Database Error ORA-29921346/19

ORA-29921: Ancillary operator not supported with set view query block

Cause: Outer view query block contains ancillary operator and view query block contains union all.

Action: Define the union-all view query to contain the primary and ancillary query terms. i.e. have the operators within the view definition rather than in the query outside the view.

Error Type: ORA

Oracle® Database Error Codes 8i | 9i | 10g | 11g | 12c | 18c | 19c

Record: 1/1

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners

Oracle: Registered trademark of Oracle