Oracle Database Errors or Warnings from Error ORA-36315 to ORA-36392


ORA-36315: (PHYS04) You must specify the VALUE option for scalar relation workspace object.
Cause: The VALUE argument to PHYSICAL was omitted for a scalar relation
Action: specify VALUE or choose a dimensioned relation
ORA-36316: (PHYS02) Relation workspace object must be a single-dimensional relation that relates one INTEGER dimension to another.
Cause: The user specified an invalid relation while attempting to use the PHYSICAL command
Action: Specify a valid relation
ORA-36340: (SNSYN130) The format of the PARTITIONCHECK function is: PARTITIONCHECK(aggmap, partition_template)
Cause: Bad syntax
Action: Correct syntax

ORA-36342: (SNSYN200) The format of the CLEAR command is: CLEAR [ ALL | STATUS ] [ AGGREGATES | CHANGES | PRECOMPUTES | NONPRECOMPUTES | CACHE ] FROM var1 [var2, var3…] [USING aggmap]
Cause: The syntax for the CLEAR command was invalid.
Action: Modify your syntax using the correct format.
ORA-36376: (XSAGZERO) AGGREGATE attempted to divide by zero. Set DIVIDEBYZERO to YES if you want NA to be returned as the result of a division by zero.
Cause: A calculation in the current AGGREGATE command attempted to divide by zero as a result of an AVERAGE, WAVERAGE, HAVERAGE or HWAVERAGE operation.
Action: Either fix the data, or set DIVIDEBYZERO to YES to return NA instead of signaling an error.
ORA-36378: (XSAGTHRWEIGHT) While running AGGREGATE with multiple threads, the weight variable workspace object specified by your ARGS variable workspace object must exist in the same analytic workspace as your AGGMAP workspace object.
Cause: While running AGGREGATE in threaded mode, you attempted to specify a WEIGHT variable in another analytic workspace.
Action: Use a weight variable from the same analytic workspace as the aggmap and rollup variable.

ORA-36380: (AGGRECURSE) AGGREGATE was called recursively, which is not allowed.
Cause: A model, NATRIGGER, or other object called the AGGREGATE function or command while another AGGREGATE function or command was already in progress.
Action: Modify your objects so that they do not need to have two AGGREGATE commands or functions executing at once.
ORA-36389: (XSAGPARTDEP01) Can not aggregate from PARTITION number into PARTITION number due to increasing sparsity along DIMENSION %J.
Cause: The user is attempting to use partitions as a means of sparsity control, however they have set up their partitions in a manner that simply makes no sense. It is a simple fact that during aggregation data becomes more dense, not less dense, and yet their partitions indicate the opposite.
Action: Modify the partition template add the specified dimension into the source composite, or removing it from the target composite.
ORA-36391: (XSMXCLEA01) When CLEAR is used with the STATUS keyword or an AGGMAP, workspace object must be dimensioned identically to workspace object.
Cause: The user specified objects whose dimensionality didn’t match
Action: Break up the CLEAR command into multiple commands where the dimensionality of the objects matches
ORA-36392: (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must specify an AGGMAP.
Cause: The user didn’t specify an AGGMAP with the CLEAR command.
Action: specify an aggmap by adding a USING phrase to the CLEAR command, or attach a ‘$AGGMAP’ property to the variable.

Above are list of Oracle Database Errors or Warnings from Error ORA-36315 to ORA-36392 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 *