QSM-01121: materialized view, string, is TRUSTED in ENFORCED
integrity mode
- 1 Answers
- 2878 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 |
ORA-39601: Hash key is required.
ORA-31428: no publication contains all the specified columns
ORA-16765: Physical apply service unexpectedly online
TNS-00110: Could not initialize network from file TNSNET.ORA
RMAN-06472: channel id string is automatically allocated
ORA-25208: RELATIVE_MSGID must be specified if SEQUENCE_DEVIATION is BEFORE
PCB-00238: Element of this table group item host variable cannot be a table
DRG-12006: Plase enter account:
ORA-12920: database is already in force logging mode
ORA-32125: Attribute type is not appropriate
what is error treshold?
ORA-29825: invalid name for indextype
Oracle Errors 
