重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

标题: ORA-36389: (XSAGPARTDEP01) Can not aggregate from PARTITION number into [打印本页]

作者: michaeljet 时间: 2016-9-5 09:21
标题: ORA-36389: (XSAGPARTDEP01) Can not aggregate from PARTITION number into

ORA-36389: (XSAGPARTDEP01) Can not aggregatefrom PARTITION number into

PARTITION number due toincreasing sparsity along DIMENSION %J.

Cause: The user is attempting to usepartitions as a means of sparsity control,

however they have set up their partitions in a mannerthat simply makes no sense.

It is a simple fact that during aggregation data becomesmore dense, not less

dense, and yet their partitions indicate the opposite.

Action: Modify the partition templateadd the specified dimension into the source

composite, or removing it from the target composite.

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)