欢迎光临
我们一直在努力

ORA-32486: unsupported operation in recursive branch of recursive WITH clause ORACLE 报错 故障修复 远程处理

文档解释

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.

ORA-32486: unsupported operation in recursive branch of recursive WITH clause:这个错误指示用户尝试执行递归WITh子句中的一项不支持的操作,即在查询的相同端中执行不同的操作,这是不允许的。

官方解释

常见案例

一般处理方法及步骤

1、检查查询是否对递归WITh子句中的相同端执行不同的操作;

2、如果存在不一致的地方,尝试更改递归WITh子句来执行统一的操作;

3、重新尝试查询,看看是否能够正确执行。

赞(0)
【声明】:本博客不参与任何交易,也非中介,仅记录个人感兴趣的主机测评结果和优惠活动,内容均不作直接、间接、法定、约定的保证。访问本博客请务必遵守有关互联网的相关法律、规定与规则。一旦您访问本博客,即表示您已经知晓并接受了此声明通告。