ORA-12839: cannot modify an object in parallel after modifying it

文档解释

ORA-12839: cannot modify an object in parallel after modifying it

Cause: Within the same transaction, an attempt was made to perform parallel modification operations on a table after it had been modified. This is not permitted.

Action: Rewrite the transaction or break it up into two transactions: one containing the parallel modification and the second containing the initial modification operation.

ORA-12839: 不能在修改对象后并行修改该对象

官方解释

ORA-12839 is thrown when an attempt is made to modify an object in parallel after modification has already been done.

此错误消息指出,试图对已修改过的对象进行并行修改。

常见案例

这个错误的一个典型的案例是,在SRV_PARALLEL_DEGREE参数被设置为一个大的值的时候,尝试运行一些创建或修改对象的请求时,ORA-12839异常会发生。

正常处理方法及步骤

1. 检查在运行修改时是否有SRV_PARALLEL_DEGREE参数被设置成NONZERO值;

2. 如果参数被设置成一个非允许值,请重新设置这个参数;

3. 尝试重新运行请求,如果还没有成功,可以考虑使用SERIAL主机参数来重新运行对象修改。

你可能感兴趣的