ORA-36389: (XSAGPARTDEP01) Can not aggregate from PARTITION number into PARTITION number due to increasing sparsity along DIMENSION %J.

ORA-36389: (XSAGPARTDEP01) Can not aggregate from PARTITION number into PARTITION number due to increasing sparsity along DIMENSION %J.
Cause: The user is attempting to use partitions as a means of sparsity control, however they have set up their partitions in a manner that simply makes no sense. It is a simple fact that during aggregation data becomes more dense, not less dense, and yet their partitions indicate the opposite.
Action: Modify the partition template add the specified dimension into the source composite, or removing it from the target composite.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:50

ORA-36389：（XSAGPARTDEP01）由于DIMENSION％J上的稀疏性增加，无法从PARTITION 编号聚合到PARTITION 编号。,
.原因：用户尝试使用分区作为稀疏控制的手段，但是他们已经以一种毫无意义的方式设置了分区。这是一个简单的事实，在聚合数据变得更加密集，而不是不那么致密，而他们的分区指示相反。,
.操作：修改分区模板将指定的维度添加到源复合体，或从目标复合体中删除它。,
.

aiaiDBA

13718043309

010-86462881

ORA-36389: (XSAGPARTDEP01) Can not aggregate from PARTITION number into PARTITION number due to increasing sparsity along DIMENSION %J.

1 个回答

相似问题