QSM-01121: materialized view, string, is TRUSTED in ENFORCED
integrity mode



QSM-01121: materialized view, string, is TRUSTED in ENFORCED integrity mode..

Answer / guest

Cause: A stale materialized view created with USING TRUSTED
CONSTRAINTS clause cannot be used when the query rewrite
integrity mode is set ENFORCED.

Action: Alter materialized view such that it has the
ENFORCED CONSTRAINTS ALTER MATERIALIZED VIEW <mv> REFRESH
USING ENFORCED CONSTRAINTS

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-27216: skgfgsmcs: sbtinfo2 returned a malformed response

1 Answers  


ORA-25151: Rollback Segment cannot be created in this tablespace

1 Answers  


ORA-33056: (XSAGDNGL27) In AGGMAP workspace object, the MAX argument of number must be greater than the CEILING argument of number.

1 Answers  


NNL-00007: server responded with an error

1 Answers  


ORA-13111: cannot add topo_geometry layer [string] to topology

1 Answers  






ORA-32610: missing SINGLE REFERENCE or DIMENSION keyword in MODEL clause

1 Answers  


ORA-01059: parse expected before a bind or execute

1 Answers  


O2U-00212: An error occurred for which no message is available

1 Answers  


ORA-23435: cannot create an updatable ROWID materialized view with LOB columns

1 Answers  


ORA-01988: remote os logon is not allowed

1 Answers  


ORA-01122: database file string failed verification check

1 Answers  


ORA-31627: API call succeeded but more information is available

1 Answers  


Categories