Oracle Database Errors or Warnings from Error ORA-37159 to ORA-37175



ORA-37159: C++ virtual table addresses become invalid due to session migration in shared server mode.
Cause: Exec-shield is the primary reason that caused this error in shared server mode. When exec-shield is turned on, there is no way to ensure that the C++ virtual table addresses are identical in all shared-server processes.
Action: Set option _XSOLAPI_FIX_VPTRS to TRUE, restart the instance, and try again.
ORA-37160: OLAP object does not exist
Cause: The specified OLAP object did not exist.
Action: Use an existing OLAP object instead.
ORA-37161: invalid privilege specified for OLAP object
Cause: An attempt was made to grant or revoke an invalid privilege on an OLAP object.
Action: Specify a valid privilege.

ORA-37162: OLAP error
Cause: An exception was raised by OLAP code.
Action: Check error messages and correct any reported problems.
ORA-37163: cannot delete or truncate AW with dependent CUBES or CUBE DIMENSIONS
Cause: User attempted to delete or truncate an AW which currently has a CUBE or CUBE DIMENSION defined over it
Action: Drop the corresponding CUBE or CUBE DIMENSION before deleting the AW
ORA-37171: dimension sources not specified
Cause: The user passed an empty or null collection to DBMS_AW.ADVISE_SPARSITY
Action: Specify a valid set of dimension sources
ORA-37172: illegal dimension type
Cause: The user specified an invalid member of the DIMTYPE field in the dimension sources argument
Action: Specify one of the valid enumerated values in DBMS_AW

ORA-37173: null dimension source data
Cause: The user specified NULL for one of the members of the dimension sources argument
Action: Specify a value
ORA-37174: source SQL must be a SELECT statement
Cause: The user specified an INSERT, UPDATE, DELETE or other type of SQL statement
Action: Specify a SQL SELECT statement instead
ORA-37175: column string is not a column of source data
Cause: A dimension column was specified which did not exist in the input data
Action: Specify one of the columns of the input data

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