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-00213: package STANDARD not accessible

1 Answers  


ORA-02367: file truncated error in string

1 Answers  


DRG-50867: failed to free Oracle object

1 Answers  


ORA-01041: internal error. hostdef extension doesn't exist

1 Answers  


ORA-27411: An empty string is not a valid repeat interval.

1 Answers  






ORA-01973: Missing change number

1 Answers  


ORA-06022: NETASY: channel open failure

1 Answers  


PLS-00636: overriding method requires OVERRIDING keyword

1 Answers  


ORA-30752: column or table string is not substitutable

1 Answers  


ORA-19330: Type 'string'.'string' not installed. Please install the type before using the CREATE_DBURI operator

1 Answers  


EXP-00082: Invalid function name passed to procedural object support: string

1 Answers  


ORA-40105: input data incompatible with model signature

1 Answers  


Categories