ORA-37138: (XSCCOMP13) You cannot delete values from workspace object because it is an aggregated COMPRESSED COMPOSITE.

ORA-37138: (XSCCOMP13) You cannot delete values from workspace object because it is an aggregated COMPRESSED COMPOSITE.
Cause: The user tried to MAINTAIN DELETE from an aggregated COMPRESSED COMPOSITE.
Action: In order to perform this sort of maintenance the composite must first be cleared. This can be done by running the CLEAR AGGREGATES command on the variable dimensioning the composite. Note that this will remove all data computed during the last AGGREGATE command.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:51

ORA-37138：（XSCCOMP13）不能从工作空间对象中删除值，因为它是聚合COMPRESSED COMPOSITE。,
.原因：用户尝试从聚合的COMPRESSED COMPOSITE中保留DELETE。,
.操作：为了执行此类维护，必须首先清除组合。这可以通过对指定复合体的变量运行CLEAR AGGREGATES命令来完成。请注意，这将删除在上一次AGGREGATE命令期间计算的所有数据。,
.

aiaiDBA

13718043309

010-86462881

ORA-37138: (XSCCOMP13) You cannot delete values from workspace object because it is an aggregated COMPRESSED COMPOSITE.

1 个回答

相似问题