Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-36260: (XSAGHIERPART00) Aggregating from partition %J to
partition %J over hierarchy workspace object creates an
increase in sparsity.
- 1 Answers
- 3140 Views
- I also Faced
- E-Mail Answers
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 |
ORA-29346: invalid tablespace list
ORA-26534: collision: tranID number ignored and purged
NNL-00257: Server-generated requests currently require authoritative answers
NZE-29048: Unexpected message received.
ORA-00218: block size string of controlfile 'string' does not match DB_BLOCK_SIZE (string)
ORA-24015: cannot create QUEUE_TABLE, QUEUE_PAYLOAD_TYPE string.string does not exist
RMAN-06098: the target database must be mounted when issuing a BACKUP command
ORA-08191: Flashback Table operation is not supported on remote tables
NNL-00963: Timeouts, name TTL expired: number
ORA-26089: LONG column "string" must be specified last
QSM-01617: equivalence definition is disabled
O2F-00313: Illegal or missing attribute name
Oracle Errors 
