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

PLS-00203: function DECODE must be called with at least 3 non-boolean arguments

1 Answers  


DRG-10606: server failed to access the DML Queue

1 Answers  


NNC-00430: Database not accessible

1 Answers  


DRG-11711: too much data for term string

1 Answers  


ORA-06574: Function string references package state, cannot execute remotely

1 Answers  






ORA-01097: cannot shutdown while in a transaction - commit or rollback first

1 Answers  


ORA-06559: wrong datatype requested, string, actual datatype is string

1 Answers  


ORA-16705: severe internal error in resource guard

1 Answers  


ORA-19802: cannot use DB_RECOVERY_FILE_DEST without DB_RECOVERY_FILE_DEST_SIZE

1 Answers  


ORA-02153: invalid VALUES password string

1 Answers  


DRG-11722: invalid language specification

1 Answers  


ORA-38461: XML Tag "string" already exists for the XMLType attribute "string"

1 Answers  


Categories