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 inc..

Answer / guest

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 thier partitions indicate the opposite.

Action: Modify the partition template add the specified
dimension into the source composite, or removing it from the
target composite.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-24152: cannot drop evaluation context string.string with dependents

1 Answers  


ORA-28101: policy already exists

1 Answers  


PLS-00435: DML statement without BULK In-BIND cannot be used inside FORALL

1 Answers   Quest,


TNS-12537: TNS:connection closed

1 Answers   IBM,


DRG-13312: user CTXSYS does not own USER_LEXER stored procedure string

1 Answers  






ORA-36904: (XSAGDNGL44) In AGGMAP workspace object, RELATION workspace object occurs after a dynamic model. The dynamic model must be the last calculation within the AGGMAP.

1 Answers  


ORA-00261: log string of thread string is being archived or modified

1 Answers  


DRG-50861: failed to obtain type descriptor

1 Answers  


ORA-13481: the destination type is not supported

1 Answers  


LSX-00145: attribute "~1S" invalid derived value "~2S"

1 Answers  


PROC-00001: Oracle Cluster Registry cannot be initialized.

1 Answers  


ORA-31041: Property string: Memory type (string) not compatible with database type (string)

1 Answers  


Categories