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

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.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

ORA-29921：集合视图查询块不支持辅助运算符,
.原因：外部视图查询块包含辅助运算符，并且视图查询块包含union all。,
.操作：定义union-all视图查询以包含主要查询术语和辅助查询术语。即在视图定义内具有运算符，而不是在视图外的查询中。,
.

aiaiDBA

13718043309

010-86462881

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

1 个回答

相似问题