QSM-01086: dimension(s) not present or not used in ENFORCED
integrity mode



QSM-01086: dimension(s) not present or not used in ENFORCED integrity mode..

Answer / guest

Cause: Query rewrite does not use dimensions in ENFORCED
query rewrite integrity mode. If a suitable dimension is
present, consider chaning the current integrity mode to
either TRUSTED or STALE_ TOLERATED by using ALTER SESSION
SET QUERY_REWRITE_INTEGRITY = command.

Action: none

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-23404: refresh group "string"."string" does not exist

1 Answers  


PCC-02133: CMD-LINE: Error in string processing function

1 Answers  


PLS-00566: type name "string" cannot be constrained

1 Answers  


RMAN-12012: multiple records for string parallelism found in catalog

1 Answers  


NNL-00991: Maximum number of reforwards per request: number

1 Answers  






QSM-00797: the specified workload string does not exist for the current user

1 Answers  


ORA-02196: PERMANENT/TEMPORARY option already specified

1 Answers  


RMAN-02004: quoted string too big

1 Answers  


ORA-16713: The resource guard timed out while servicing the request.

1 Answers  


ORA-12696: Double Encryption Turned On, login disallowed

1 Answers  


ORA-13908: Invalid combination of metrics id and object type parameters.

1 Answers  


RMAN-06075: datafile string does not belong to this database

1 Answers  


Categories