ORA-32582: table function with left correlation to a table cannot also be left outer-joined to the table

ORA-32582: table function with left correlation to a table cannot also be left outer-joined to the table
Cause: A table function T2 contains a reference to a table T1. T2 is also left outer-joined to T1. This is not allowed.
Action: Remove the reference to T1 from T2 or remove the left outer-join specification (+).

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:50

ORA-32582：具有与表的左相关性的表函数不能也被外部连接到表,
.原因：表函数T2包含对表T1的引用。T2也被外部连接到T1。这是不允许的。,
.操作：从T2中删除对T1的引用或删除左外连接规范（+）。,
.

aiaiDBA

13718043309

010-86462881

ORA-32582: table function with left correlation to a table cannot also be left outer-joined to the table

1 个回答

相似问题