QSM-01121: materialized view, string, is TRUSTED in ENFORCED
integrity mode
- 1 Answers
- 2030 Views
- I also Faced
- E-Mail Answers
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 |
NZE-29023: The buffers are not empty.
ORA-27061: waiting for async I/Os failed
DRG-11618: URL store: document identified by string is too large
ORA-08318: sllfsk: Error reading file
TNS-01167: The command string is not supported by the listener contacted
ORA-39726: unsupported add/drop column operation on compressed tables
ORA-16050: destination exceeded specified quota size
NNL-01053: Request processing enabled: string
ORA-31667: parameter name can not be defaulted
DRG-11619: URL store: row in table is empty
ORA-13431: GeoRaster metadata rasterType error
ORA-00354: corrupt redo log block header
Oracle Errors 
