QSM-01084: materialized view, string, has anchor, string,
not found in query
- 1 Answers
- 2521 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: A table in a materialized view is an anchor, (a) if
it is not joined to any other table or (b) joined to other
tables but each of its joins is either lossy or lossless
with the above table being child-side table. If an anchor
which is present in the materialized view is not found in
the query, then query rewrite will not take place.
Action: none
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-31509: publication does not exist
IMG-00861: assert failure, inconsistency in area merge operation
NZE-28844: No wallet present
ORA-02268: referenced table does not have a primary key
ORA-02841: Server died on start up
KUP-04104: zoned decimal field has bad values for string
QSM-01618: equivalence, string, is enabled for text match rewrite only
ORA-19623: file string is open
ORA-16732: Error executing dbms_logstdby.skip procedure
ORA-04060: insufficient privileges to execute string
LFI-00131: No open type specified.
ORA-07610: $GETJPIW failed in retrieving the user's MAC priviledges
Oracle Errors 
