ORA-36260: (XSAGHIERPART00) Aggregating from partition %J to
partition %J over hierarchy workspace object creates an
increase in sparsity.
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 |
PCC-00010: Statement out of place at line number in file string
NZE-29239: the cryptographic engine could not initialize the algorithm
TNS-00041: INTCTL: Navigator already running. Start operation cancelled
ORA-00365: the specified log is not the correct next log
ORA-25107: duplicate TABLESPACE option specification
ORA-12404: invalid privilege string: string
ORA-23372: type string in table string is unsupported
ORA-06523: Maximum number of arguments exceeded
ORA-36669: (XSDPART07) string is not a legal LIST partition.
LSX-00011: internal error: ~s
IMG-00716: source image format does not support process options
DRG-52207: the specified attribute does not exist: string