ORA-37530: (XSCCLOAD01) When aggregating between compressed partitions the base dimensions of workspace object did not match the base dimensions of workspace object.

ORA-37530: (XSCCLOAD01) When aggregating between compressed partitions the base dimensions of workspace object did not match the base dimensions of workspace object.
Cause: When aggregating a partitioned variable the dimensionality of any compressed partitions should be identical.
Action: Delete the upper partition and redefine it with a composite that matches the lower partition. If it is dependent on multiple partitions with varying sparsity you must first unify the the sparsity of the source partitions.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:51

ORA-37530：（XSCCLOAD01）在压缩分区之间进行聚合时，工作空间对象的基本维度与工作空间对象的基本维度不匹配。,
.原因：在聚合分区变量时，任何压缩分区的维度应该相同。,
.操作：删除上部分区，并使用与下部分区匹配的复合体重新定义它。如果它依赖于具有不同稀疏性的多个分区，则必须首先统一源分区的稀疏性。,
.

aiaiDBA

13718043309

010-86462881

ORA-37530: (XSCCLOAD01) When aggregating between compressed partitions the base dimensions of workspace object did not match the base dimensions of workspace object.

1 个回答

相似问题