Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-01121: materialized view, string, is TRUSTED in ENFORCED
integrity mode
- 1 Answers
- 3383 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 |
RMAN-06090: error while looking up controlfile copy: string
RMAN-12019: continuing other job steps, job failed will not be re-run
TNS-00247: Unable to allocate memory for configuration data from TNSNET.ORA file
ORA-13356: adjacent points in a geometry are redundant
ORA-31078: error in SQL mapping information
ORA-24156: duplicate table alias string
PLS-00211: CASE labels or ranges must not be duplicated in different WHEN clauses
IMP-00004: invalid username or password
ORA-02026: missing LINK keyword
DRG-10511: index string does not exist or is incomplete
ORA-09969: scurls: unable to close lock file
ORA-31109: Action failed as parent resource string is locked
Oracle Errors 
