Category Archives: ORA Database Error Messages

ORA-36710: (XSMXALLOC01) TARGETLOG variable workspace object must be dimensioned identically to TARGET variable workspace object

oracle

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

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-36708: (XSMXALLOC00) Variable workspace object must be dimensioned to be used by the ALLOCATE command

oracle

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

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-36706: (XSRELTBL07) workspace object should be dimensioned by workspace object and one level dimension

oracle

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

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-36704: (XSRELTBL06) workspace object should be dimensioned by workspace object

oracle

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 

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-36702: (XSRELTBL05) The format of the HIERHEIGHT function is: HIERHEIGHT(relation [,] level) level >= 1

oracle

 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

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-36700: (XSRELTBL04) Dimension workspace object cannot be qualified more than once

oracle

ORA-36700: (XSRELTBL04) Dimension workspace object cannot be qualified more than once
Cause: The same dimension was specified more than once in the QDR
Action: Specify each QDR dimension only once

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/

ORA-36698: (XSRELTBL03) QDR dimension workspace object should be in the dimension list that dimensions the relation

oracle

ORA-36698: (XSRELTBL03) QDR dimension workspace object should be in the dimension list that dimensions the relation
Cause: The named dimension was not in the relation's dimension list
Action: Select only dimensions that are in the relation's dimension list

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-36696: (XSRELTBL02) QDR dimension workspace object should not be the related dimension of the relation

oracle

ORA-36696: (XSRELTBL02) QDR dimension workspace object should not be the related dimension of the relation
Cause: An ineligible dimension was specified in the Qualified Data Reference
Action: Do not attempt to qualify this dimension

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-36694: (XSRELTBL01) The value cannot be added to dimension workspace object

oracle

ORA-36694: (XSRELTBL01) The value cannot be added to dimension workspace object
Cause: Unknown
Action: Check the context and permission for dimension maintenance

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/

ORA-36692: (XSRELTBL00) The format of the HIERHEIGHT command is: HIERHEIGHT relation1[(dimension dimvalue, …)] into relation2 [using relation3 | a | d] [levelorder lovs] [inhierarchy {variable | valueset}]

oracle

ORA-36692: (XSRELTBL00) The format of the HIERHEIGHT command is: HIERHEIGHT relation1[(dimension dimvalue, ...)] into relation2 [using relation3 | a | d] [levelorder lovs] [inhierarchy {variable | valueset}]
Cause: The user input the wrong format/object types
Action: Make sure number of arguments and all object types are correct

Back to previous menu

https://support.oracle.com/
http://www.oracle.com/