Oracle Database Errors or Warnings from Error ORA-37082 to ORA-37105


ORA-37082: Invalid percent
Cause: A request was made for advice with an illegal percent value.
Action: Request between 0 and 100 percent precomputation.
ORA-37083: Invalid object string
Cause: A request was made for advice with an illegal object name.
Action: Request using valid object names.
ORA-37084: Output valueset string must match string’s dimensionality
Cause: A request was made for advice for a relation with different dimensionality from the output valueset.
Action: Request using objects that have the same dimensionality.

ORA-37086: string is not a valueset
Cause: An operation was attempted that supports only valuesets as precompute expressions in an aggmap, yet a different kind of precompute expression was used.
Action: Replace this limit expression with an equivalent valueset and retry the operation. General precompute expressions are deprecated.
ORA-37100: (XSUNCOMMITTED) You have one or more updated but uncommitted analytic workspaces.
Cause: The user has attempted to shut down OLAP, but they have active analytic workspaces whose changes have not been saved.
Action: Issue the commit command. —- 37101 – 37110 are reserved for partitioned variables —-
ORA-37101: (XSVPART01) Partitioning information can only be given for variables dimensioned by a PARTITION TEMPLATE.
Cause: User attempted to define or reference an AW object with the “all internal” phrase or internal / external partition list, but the object was not a variable, was not dimensioned by a partition template, or was an already existing target of an external partition.
Action: Eliminate phrases specific to partitioned variables from the definition string, or dimension the variable by a partition template.

ORA-37102: (XSVPART02) Invalid partition name string.
Cause: The user gave an invalid partition name. When defining a partitioned variable, this message indicates that the partition name does not exist in the partition template. In any other context, it indicates that the partitioned variable or partition template does not have a partition with the given name.
Action: Supply a valid partition name.
ORA-37103: (XSVPART03) The dimensionality or datatype of workspace object does not match the dimensionality or datatype of the partition.
Cause: User attempted to define a partitioned variable with an external partition, but the target of the external partition had incorrect dimensionality or datatype.
Action: Pick a different target variable. The target variable must be dimensioned by exactly the same dimensions, composites, and partition templates, in the same order, as are specified in the partition template, and must have the exact same datatype (including width, precision, and scale) as the partitioned variable itself.
ORA-37104: (XSVPART04) A partitioned variable must be dimensioned by a single partition template only.
Cause: User attempted to define a partitioned variable with more than one partition templates, or a partition template and one or more other dimensions, in the dimension list.
Action: Use only a partition template in the dimension list of the variable. All dimensions of the variable must be included in the definition of the partition template.
ORA-37105: (XSVPART05) Only variables dimensioned by a CONCAT PARTITION TEMPLATE can have string partitions.
Cause: User attempted to create an external partition on a partitioned variable, but the variable was dimensioned by a RANGE or LIST partition template.
Action: Declare the partition INTERNAL instead of EXTERNAL, or use a CONCAT partition template in place of the RANGE or LIST partition template.

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