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

DRG-10850: CTXRULE indextype does not support the operator

1 Answers  


ORA-25182: feature not currently available for index-organized tables

1 Answers  


ORA-22296: invalid ALTER TABLE option for conversion of LONG datatype to LOB

1 Answers  


PLS-00614: creating a FINAL NOT INSTANTIABLE type

1 Answers  


ORA-16210: Logical standby coordinator process terminated with error

1 Answers  






ORA-22920: row containing the LOB value is not locked

1 Answers  


ORA-01576: The instance string is not enabled

1 Answers  


ORA-13050: unable to construct spatial object

1 Answers  


RMAN-06750: SPFILE cannot be backed up by proxy.

1 Answers  


ORA-01083: value of parameter "string" is inconsistent with that of other instances

1 Answers  


SQL*Loader-00416: SDF clause for field string in table string references a non existent field.

1 Answers  


ORA-02708: osnrntab: connect to host failed, unknown ORACLE_SID

1 Answers  


Categories