ORA-32486: unsupported operation in recursive branch of recursive WITH clause

ORA-32486: unsupported operation in recursive branch of recursive WITH clause
Cause: The recursive component of the UNION ALL in a recursive WITH clause element used an operation that was currently not supported. The following should not be used in the recursive branch of the UNION ALL operation: GROUP BY, DISTINCT, MODEL, grouping sets, CONNECT BY, window functions, HAVING, aggregate functions.
Action: Rewrite the query without the unsupported operation.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:50

ORA-32486：递归WITH子句的递归分支中不支持的操作,
.原因：递归WITH子句元素中的UNION ALL的递归组件使用当前不支持的操作。以下不应用于UNION ALL操作的递归分支：GROUP BY，DISTINCT，MODEL，分组集，CONNECT BY，窗口函数，HAVING，聚合函数。,
.操作：重写查询而不使用不支持的操作。,
.

aiaiDBA

13718043309

010-86462881

ORA-32486: unsupported operation in recursive branch of recursive WITH clause

1 个回答

相似问题