Oracle Database Errors or Warnings from Error ORA-36702 to ORA-36722


ORA-36702: (XSRELTBL05) The format of the HIERHEIGHT function is: HIERHEIGHT(relation [,] level) level >= 1.
Cause: The HIERHEIGHT function was specified incorrectly.
Action: Make sure the format is correct.
ORA-36704: (XSRELTBL06) workspace object should be dimensioned by workspace object.
Cause: The level relation is not dimensioned by the source relation dimension.
Action: Make sure the level relation has the correct definition.
ORA-36706: (XSRELTBL07) workspace object should be dimensioned by workspace object and one level dimension.
Cause: The destination relation has the wrong definition.
Action: Make sure the destination relation has the correct dimensions.

ORA-36708: (XSMXALLOC00) Variable workspace object must be dimensioned to be used by the ALLOCATE command.
Cause: The user supplied an undimensioned (scalar) variable to the ALLOCATE command.
Action: Use a dimensioned variable.
ORA-36710: (XSMXALLOC01) TARGETLOG variable workspace object must be dimensioned identically to TARGET variable workspace object.
Cause: The user attempted to execute ALLOCATE with mismatching TARGET and TARGETLOG variables
Action: Use TARGET and TARGETLOG variables with matching dimensionality.
ORA-36712: (XSMXALLOC02) Relation workspace object must be a one-dimensional self-relation to be used as a SOURCE or BASIS with ALLOCATE.
Cause: The user specified an invalid source or basis relation on the ALLOCATE command line.
Action: Modify the relation to be a one-dimensional self-relation.

ORA-36714: (XSMXALLOC03) TARGETLOG variable workspace object must have the same data type as TARGET variable workspace object.
Cause: The user specified a TARGETLOG variable that had a different data type from the TARGET variable.
Action: Use TARGETLOG and TARGET variables with an identical data type.
ORA-36718: (XSALLOC00) You do not have the necessary permissions to use AGGMAP workspace object.
Cause: The user did not have sufficient permissions to run the ALLOCATE command
Action: Change to a user ID with the appropriate permissions, or use objects that you have permission to use.
ORA-36720: (XSALLOC01) To be used with ALLOCATE, your AGGMAP workspace object must be defined with the ALLOCMAP command.
Cause: The user used the AGGMAP command to define the AGGMAP, so either the AGGMAP can only be used with the AGGREGATE command, or the AGGMAP has no contents attached to it.
Action: Use the ALLOCMAP command to define the AGGMAP.
ORA-36722: (XSALLOC02) In AGGMAP workspace object, you specified an NA or ZERO sourceval but supplied formula workspace object as your source for ALLOCATE.
Cause: The user requested that source values be modified during the allocation, but that is not possible when using a formula source.
Action: Either use a VARIABLE source or remove the SOURCEVAL specification for your ALLOCMAP.

Above are list of Oracle Database Errors or Warnings from Error ORA-36702 to ORA-36722 received while performing certain operation against Oracle Database or related products.

What are atOracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Dabase Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *