ORA-36260: (XSAGHIERPART00) Aggregating from partition %J to partition %J

ORA-36260
ORA-36260: (XSAGHIERPART00) Aggregating from partition %J to partition %J
over hierarchy workspace object creates an increase in sparsity.
Cause: In the partition creation / aggmap creation a situation developed such that
when aggregating over a particular dimension of the aggmap a partition boundary
was crossed such that the sparsity of the target partition included dimensions that
were not in the sparsity 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
18-28 Oracle Database Error Messages

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 its composite.
More details : Viste http://www.high-oracle/ora-36260/
More details : Viste http://www.high-oracle/ora-36260/
-------------------------------------------------------

-------------------------------------------------------
Viste our Support Blog : http://updatefun.blogspot.fr/
Viste our Support Blog : http://oracleerrormsgs.blogspot.fr/
Viste our Support Blog : http://oracleerror1.blogspot.fr/
Viste our Support Blog : http://oracleerrorcodelist.blogspot.fr/
Viste our Support Blog : http://all-dba-support.blogspot.fr/
Viste our Support Blog : http://my-support-oracle.blogspot.fr/
-------------------------------------------------------

Your source for help on all Oracle database error codes :
------------------------
ORA-09746: smscre: shared memory attach address incorrect.
ORA-29887: cannot support row movement if domain index defined on table
ORA-25103: NOPARALLEL option can only be used with ALTER INDEX REBUILD
ORA-31182: Too many PL/SQL DOM handles specified
ORA-06255: NETNTT: cannot read pid of remote process
ORA-00993: missing GRANT keyword
ORA-30449: syntax error in parameter
ORA-13421: null or invalid cell value
ORA-19237: XP0017 - unable to resolve call to function - :
ORA-31065: Cannot modify read-only property []
ORA-16196: database has been previously opened and closed
ORA-07684: sou2os: supervisor stack reset error
ORA-24784: Transaction exists
ORA-27040: file create error, unable to create file
ORA-06701: TLI Driver: incorrect number of bytes written
ORA-29052: Write buffer is not empty.
ORA-07478: scgcmn: cannot get lock status.
ORA-25233: invalid parameter specified for NAVIGATION
ORA-25232: duplicate recipients specified for message
ORA-10237: simulate ^C (for testing purposes)
-------------------------------------------------------
Error Oracle : ora-02028 http://www.high-oracle.com/ora-02028/
Error Oracle : ora-24906 http://www.high-oracle.com/ora-24906/
Error Oracle : ora-14521 http://www.high-oracle.com/ora-14521/
Error Oracle : ora-13770 http://www.high-oracle.com/ora-13770/
Error Oracle : ora-29740 http://www.high-oracle.com/ora-29740/
Error Oracle : ora-30745 http://www.high-oracle.com/ora-30745/
Error Oracle : ora-02258 http://www.high-oracle.com/ora-02258/
Error Oracle : ora-33425 http://www.high-oracle.com/ora-33425/
Error Oracle : ora-07672 http://www.high-oracle.com/ora-07672/
Error Oracle : ora-30656 http://www.high-oracle.com/ora-30656/
Error Oracle : ora-02469 http://www.high-oracle.com/ora-02469/
Error Oracle : ora-24120 http://www.high-oracle.com/ora-24120/
Error Oracle : ora-19662 http://www.high-oracle.com/ora-19662/
Error Oracle : ora-31025 http://www.high-oracle.com/ora-31025/
Error Oracle : ora-02098 http://www.high-oracle.com/ora-02098/
Error Oracle : ora-30108 http://www.high-oracle.com/ora-30108/
Error Oracle : ora-02252 http://www.high-oracle.com/ora-02252/
Error Oracle : ora-32629 http://www.high-oracle.com/ora-32629/
Error Oracle : ora-28236 http://www.high-oracle.com/ora-28236/
Error Oracle : ora-22150 http://www.high-oracle.com/ora-22150/
-------------------------------------------------------
Viste our Support Blog : http://updatefun.blogspot.fr/
Viste our Support Blog : http://oracleerrormsgs.blogspot.fr/
Viste our Support Blog : http://oracleerror1.blogspot.fr/
Viste our Support Blog : http://oracleerrorcodelist.blogspot.fr/
Viste our Support Blog : http://all-dba-support.blogspot.fr/
Viste our Support Blog : http://my-support-oracle.blogspot.fr/
-------------------------------------------------------

Enregistrer un commentaire

0 Commentaires