ORA-37134: (XSCCOMP09) You cannot add new values to workspace object because it includes positions for precomputed aggregate values.

ORA-37134: (XSCCOMP09) You cannot add new values to workspace object because it includes positions for precomputed aggregate values.
Cause: The user attempted to create a new position in a compressed composite, either directly (using MAINTAIN MERGE or MAINTAIN ADD) or by storing a value into the variable dimensioned by the compressed composite. This is not allowed when the variable has been precomputed using the AGGREGATE command. Once the AGGREGATE command is run on a variable dimensioned by a compressed composite, the compressed composite becomes read-only until the computed values are removed with the CLEAR command.
Action: Run the CLEAR AGGREGATES command to remove the computed values from the variable and then rerun the failed operation. Note that CLEAR AGGREGATES will remove all the data computed during the last AGGREGATE command on this variable.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:51

ORA-37134：（XSCCOMP09）无法向工作空间对象添加新值，因为它包括预计算聚合值的位置。,
.原因：用户尝试直接（使用MAINTAIN MERGE或MAINTAIN ADD）在压缩复合材料中创建新位置，或者将值存储到由压缩复合材料标注的变量中。当使用AGGREGATE命令预先计算变量时，不允许这样做。一旦AGGREGATE命令对由压缩复合体确定的变量运行，压缩复合体将变为只读，直到使用CLEAR命令删除计算值。,
.操作：运行CLEAR AGGREGATES命令从变量中删除计算值，然后重新运行失败的操作。请注意，CLEAR AGGREGATES将删除在此变量上最后一次AGGREGATE命令期间计算的所有数据。,
.

aiaiDBA

13718043309

010-86462881

ORA-37134: (XSCCOMP09) You cannot add new values to workspace object because it includes positions for precomputed aggregate values.

1 个回答

相似问题