aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

PLS-00654: PARTITION/ORDER/CLUSTER BY are allowed for only with PARALLEL_ENABLE

PLS-00654: PARTITION/ORDER/CLUSTER BY are allowed for only with PARALLEL_ENABLE
Cause: User tried partion by order by cluster by without parallel enable clause in table function.
Action: specify parallel enable also when using partion by, cluster by order by clause.

请先 登录 后评论

1 个回答

小智
PLS-00654:PARTITION / ORDER / CLUSTER BY只允许使用PARALLEL_ENABLE,
.原因:用户通过簇的顺序尝试了partion,而在表函数中没有使用parallel enable子句。,
.操作:指定并行使能,当使用partion by,cluster by order by子句时。,
.
请先 登录 后评论