Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

NZE-29023: The buffers are not empty.

1 Answers  


ORA-27061: waiting for async I/Os failed

2 Answers  


DRG-11618: URL store: document identified by string is too large

1 Answers  


ORA-08318: sllfsk: Error reading file

1 Answers  


TNS-01167: The command string is not supported by the listener contacted

1 Answers  






ORA-39726: unsupported add/drop column operation on compressed tables

1 Answers  


ORA-16050: destination exceeded specified quota size

1 Answers  


NNL-01053: Request processing enabled: string

1 Answers  


ORA-31667: parameter name can not be defaulted

1 Answers  


DRG-11619: URL store: row in table is empty

1 Answers  


ORA-13431: GeoRaster metadata rasterType error

1 Answers  


ORA-00354: corrupt redo log block header

1 Answers  






Categories