ORA-36608: (XSAGHOVERFLOW) The depth of the hierarchies
encountered while processing a composite dimension in
AGGREGATE caused a counter overflow.



ORA-36608: (XSAGHOVERFLOW) The depth of the hierarchies encountered while processing a composite di..

Answer / guest

Cause: The depth of the hierarchies that are part of a
composite exceeded 4 billion levels during the merge.

Action: Reduce the number of levels in the hierarchies,
reduce the number of dimensions in the composite, or do not
aggregate over all dimensions at once.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-32577: username must be SYS or SYSTEM

1 Answers  


ORA-23305: internal deferred RPC error: string

1 Answers  


RMAN-06437: cannot drop catalog - catalog is newer than this RMAN

1 Answers  


RMAN-08024: channel string: restore complete

1 Answers  


ORA-27204: skgfpqr: sbtpcqueryrestore returned error

1 Answers  






ORA-24083: cannot specify remote subscribers for string QUEUE string

1 Answers  


ORA-12994: drop column option only allowed once in statement

1 Answers  


RMAN-06094: datafile string must be restored

1 Answers  


ORA-06977: X.25 Driver: X.25 Level 2 failure

1 Answers  


RMAN-08074: crosschecked backup piece: found to be 'string'

1 Answers  


CLSS-03201: An attempt to begin a nested reconfiguration failed.

1 Answers  


DRG-11404: no primary key value specified

1 Answers  


Categories