Oracle Database Errors or Warnings from Error ORA-37139 to ORA-37148
ORA-37139: (XSCCOMP14) Cannot AGGREGATE workspace object using AGGMAP workspace object because you can not AGGREGATE a variable dimensioned by a COMPRESSED COMPOSITE using an AGGMAP with a PROTECT clause.
Cause: The user tried to AGGREGATE a variable dimensioned by a COMPRESSED COMPOSITE with an AGGMAP that included a PROTECT clause.
Action: Modify the aggmap or create a new aggmap that does not include a PROTECT clause and reaggregate.
ORA-37140: (XSCCOMP15) Cannot AGGREGATE partitioned variable workspace object using AGGMAP workspace object because you cannot use the base of a COMPRESSED COMPOSITE as a partition dimension.
Cause: The user tried to run aggregate on a partitioned variable with a partition dimension that is a base of a COMPRESSED COMPOSITE.
Action: Repartition the data, drop the partition dimension from the aggmap, or don’t use COMPRESSED COMPOSITES.
ORA-37141: (XSSQLMDQ01) Invalid host variable syntax for MDQUERY procedure.
Cause: The schema and analytic workspace name for the MDQUERY cursor declaration were incorrectly specified.
Action: Specify the schema and awname as a host variable name preceded by a colon, or as a text literal string of the form ‘SCHEMA.AWNAME’ or ‘*.*’ (quotes optional).
ORA-37142: (XSSQLMDQ02) Invalid host variable data type for MDQUERY procedure: string expected.
Cause: The user specified a host variable that was not of the correct type.
Action: Choose a different host variable.
ORA-37143: (XSSQLMDQ03) string is not a valid analytic workspace name.
Cause: The user specified an analytic workspace name not qualified by a schema name, or one or both components of the name exceed the maximum length
Action: Specify a schema-qualified analytic workspace name with components no longer than 30 characters long.
ORA-37144: (MDQUERY01) string is not a valid metadata object type for MDQUERY.
Cause: The user specified an unrecognized first argument to MDQUERY
Action: Specify a recognized object type (CUBE or DIMENSION)
ORA-37145: (XSTTS_PLAT) Cannot transport analytic workspace across platforms.
Cause: The user attempted to transport a tablespace containing an analytic workspace from one platform to another.
Action: Use export/import to move an analytic workspace across platforms.
ORA-37146: (XSCCOMP18) The variable workspace object is already dimensioned by the COMPRESSED COMPOSITE workspace object.
Cause: An attempt was made to define the partition template dimensioned by the COMPRESSED COMPOSITE which had dimensioned the variable.
Action: Define the second COMPRESSED COMPOSITE.
ORA-37147: (XSCCOMP21) The variable workspace object must be in the current operation group of the COMPRESSED COMPOSITE workspace object.
Cause: The variable dimensioned by the COMPRESSED COMPOSITE was not in the object list of the current operation group. For AGGREGATE, all variables dimensioned by the same COMPRESSED COMPOSITE also must use the same aggmap
Action: Add the variable into the object list of the current operation group.
ORA-37148: (XSCCOMP22) workspace object is an aggregated COMPRESSED COMPOSITE.
Cause: Defined the variable or partition template with the aggregated COMPRESSED COMPOSITE.
Action: Clear the COMPRESSED COMPOSITE or use a new COMPRESSED COMPOSITE
Above are list of Oracle Database Errors or Warnings from Error ORA-37139 to ORA-37148 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.
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.