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-26093: input data column size (number) exceeds the maximum input size (number)

1 Answers  


ORA-08115: can not online create/rebuild this index type

1 Answers  


RMAN-08032: channel string: recid string stamp string does not match recovery catalog

1 Answers  


ORA-01373: insufficient memory for staging persistent LogMiner session

1 Answers  


ORA-16120: dependencies being computed for transaction at SCN string

1 Answers  






ORA-32107: internal OCI memory allocation failure

1 Answers  


ORA-38720: Missing log file number.

1 Answers  


IMG-00921: threshold out of range

1 Answers  


ORA-02167: LOGFILE clause specified more than once

1 Answers  


TNS-01000: spawn [<listener_name>] <spawn_alias> [<(ARGUMENTS='arg0, arg1,...')>]

1 Answers  


ORA-27089: unable to release advisory lock

1 Answers  


DRG-11816: Use Proxy

1 Answers  


Categories