ORA-37140: (XSCCOMP15) Cannot AGGREGATE partitioned variable workspace object using AGGMAP workspace object because you cannot use the base of a COMPRESSED COMPOSITE as a partition dimension.

ORA-37140: (XSCCOMP15) Cannot AGGREGATE partitioned variable workspace object using AGGMAP workspace object because you cannot use the base of a COMPRESSED COMPOSITE as a partition dimension.
Cause: The user tried to run aggregate on a partitioned variable with a partition dimension that is a base of a COMPRESSED COMPOSITE.
Action: Repartition the data, drop the partition dimension from the aggmap, or don't use COMPRESSED COMPOSITES.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:51

ORA-37140：（XSCCOMP15）无法使用AGGMAP工作空间对象 AGGREGATE分区变量工作空间对象，因为您不能使用COMPRESSED COMPOSITE的基础作为分区维度。,
.原因：用户尝试对具有作为COMPRESSED COMPOSITE基础的分区维度的分区变量运行聚合。,
.操作：重新分区数据，从aggmap中删除分区维度，或不使用COMPRESSED COMPOSITES。,
.

aiaiDBA

13718043309

010-86462881

ORA-37140: (XSCCOMP15) Cannot AGGREGATE partitioned variable workspace object using AGGMAP workspace object because you cannot use the base of a COMPRESSED COMPOSITE as a partition dimension.

1 个回答

相似问题