Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.



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-09270: szalloc: error allocating memory for security

1 Answers  


SQL*Loader-00551: internal error: error initializing slf

1 Answers  


PLS-00639: NCHAR/NVARCHAR2 cannot be byte length semantics

1 Answers  


ORA-04022: nowait requested, but had to wait to lock dictionary object

2 Answers   Oracle,


ORA-12315: database link type is invalid for the ALTER DATABASE statement

1 Answers  


NZE-29118: Cannot create PKCS #12 attributes.

1 Answers  


RMAN-06479: WARNING: control file copy 'string' cannot be found on disk

1 Answers  


PLS-01507: DROP is non-ANSI

1 Answers  


ORA-38497: Expression Filter index does not exist

1 Answers  


TNS-01090: No longer listening on: string

1 Answers  


ORA-31665: mode can only be defaulted for IMPORT and SQL_FILE operations

1 Answers  


ORA-14289: cannot make local index partition of Composite Range partitioned table unusable

1 Answers  


Categories