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

RMAN-06703: could not open file: "string" (reason=string)

1 Answers  


ORA-23534: missing column in materialized view container table "string"."string"

1 Answers  


ORA-13294: cannot transform geometry containing circular arcs

1 Answers  


ORA-04011: sequence string must range between string and string

1 Answers  


ORA-38956: Target platform string not cross platform compliant

1 Answers  






ORA-12805: parallel query server died unexpectedly

1 Answers  


ORA-28139: Maximum allowed Fine Grain Audit Policies Exceeded

1 Answers  


IMP-00002: failed to open string for read

1 Answers  


RMAN-04006: error from auxiliary database: string

1 Answers  


ORA-26000: partition load specified but table string is not partitioned

1 Answers  


QSM-02171: the materialized view has a join operation in the outer UNION block

1 Answers  


UDI-00011: parameter string is incompatible with parameter string

1 Answers  


Categories