Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-36260: (XSAGHIERPART00) Aggregating from partition %J to
partition %J over hierarchy workspace object creates an
increase in sparsity.



ORA-36260: (XSAGHIERPART00) Aggregating from partition %J to partition %J over hierarchy workspace ..

Answer / guest

Cause: In the partition creation / aggmap creation a
situation developed such that when aggregating over a
particular dimension of the aggmap a partition boundery was
crossed such that the sparsity of the target partition
included dimensions that were not in the sparisty of the
source partition. Since the process of aggregation always
densifies rather than sparsifying this is an extremely
suboptimal design and it is not supported by the aggregate
system.

Action: Set up your partitioning such that for any partition
boundary the source and target partitions of the aggregation
will always move towards denser partitions. For any child
(c) and any parent (p) where (c) and (p) are in different
partitions it must be the case that the parent partition
contains no dimension in the composite that the child
partition does not contain in it's 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-13620: The task or object string is read-only and cannot be deleted or modified.

1 Answers  


LPX-00217: invalid character ~1u (~2x)

1 Answers  


RMAN-06123: operation not supported without the recovery catalog or mounted controlfile

1 Answers  


ORA-33006: (XSAGDNGL02) The relation workspace object is not related to itself.

1 Answers  


RMAN-06117: cannot do DELETE EXPIRED on an object which is not expired

1 Answers  






PCB-00401: Character string not properly terminated

1 Answers  


ORA-25350: maximum number of concurrent transaction branches exceeded

1 Answers  


ORA-02218: invalid INITIAL storage option value

1 Answers  


DGM-16910: unable to issue command to server

1 Answers  


ORA-02427: create view failed

1 Answers  


ORA-27475: "string.string" must be a string

1 Answers  


PLS-00227: subprogram 'in' formal string is not yet denotable

1 Answers  


Categories