Oracle Database Errors or Warnings from Error ORA-36393 to ORA-36404

SQLServerF1

ORA-36393: (XSMXCLEA03) When using the AGGREGATES, CHANGES or CACHE options, you must specify the ALL keyword.
Cause: The user didn’t use the ALL keyword when using CHANGES or CACHE.
Action: Specify the ALL keyword.
ORA-36394: (XSMXCLEA04) When using CLEAR on the AGGMAP workspace object, CACHE is the only valid directive.
Cause: The user attempted to CLEAR an AGGMAP using a directive other than CACHE.
Action: Amend the CLEAR line to only use the CACHE keyword with AGGMAPs.
ORA-36395: (XSMXCLEA05) To CLEAR ALL AGGREGATES from workspace object, you must specify an AGGMAP.
Cause: The CLEAR command could not determine how the variable was aggregated because the variable is not dimensioned by a compressed composite.
Action: Specify an aggmap by adding a USING phrase to the CLEAR command, or attach a ‘$AGGMAP’ property to the variable.

ORA-36398: (XSSPROP01) Property name ‘number’ is invalid because only system-reserved property names can begin with ‘$’.
Cause: The user attempted to add a property which starts with $ but is not a reserved property name
Action: Remove the $ from the property name
ORA-36399: (XSSPROPDTYPE) The data type of property string must be string.
Cause: The user tried to set a system-reserved property on an OLAP object to a value with an illegal datatype
Action: Set the property with the proper datatype
ORA-36400: (XSSPROP02) workspace object is not a valid variable name.
Cause: Not a valid variable name
Action: Change to a valid variable name
ORA-36401: (XSSPROPOTYPE) Property string may only be applied to objects of type string.
Cause: The user applied a reserved property name to an incorrect object type
Action: Apply the property to the correct object

ORA-36402: (XSSPROP03) The property ‘$string’ requires a leading “$” because it is a system-reserved property name.
Cause: The user tried to specify a property name which is reserved, but did not use a leading $
Action: Either add a leading $ or choose another property name
ORA-36403: (XSBADSPROP) number is an illegal value for system-reserved property string on workspace object.
Cause: The user tried to specify an illegal value for a special property
Action: Specify a legal value.
ORA-36404: (XSSPROP04) Property string cannot be applied to an undimensioned (scalar) TEMPORARY variable.
Cause: The user applied a reserved property name to an incorrect object type
Action: Apply the property to the correct object

Above are list of Oracle Database Errors or Warnings from Error ORA-36393 to ORA-36404 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.

Thanks,
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 *