ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.

ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.
Cause: An attempt was made to select FOR UPDATE from a view which had not been merged because the view used syntax (for example, DISTINCT or GROUP BY) preventing the merge, or because of initialization file parameter settings.
Action: Determine the reason the view will not merge and, if possible, make changes so that it can.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:37

ORA-02014：不能从DISTINCT，GROUP BY等视图中选择FOR UPDATE。,
.原因：尝试从尚未合并的视图中选择FOR UPDATE，因为视图使用语法（例如DISTINCT或GROUP BY）阻止合并，或者因为初始化文件参数设置。,
.操作：确定视图不会合并的原因，如果可能，进行更改以便可以。,
.

aiaiDBA

13718043309

010-86462881

ORA-02014: cannot select FOR UPDATE from view with DISTINCT, GROUP BY, etc.

1 个回答

相似问题