QSM-01084: materialized view, string, has anchor, string,
not found in query
- 1 Answers
- 2276 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 |
TNS-01060: The password has has been set to: string
ORA-12468: max write level does not equal max read level
AMD-00101: cannot create string "string"; metadata entity already exists
TNS-00079: * log_off - ask process_name to turn logging off
ORA-15102: invalid POWER expression
ORA-12403: invalid internal label
PLS-00123: program too large
ORA-19560: %s is not a valid device limit
ORA-30000: missing either trim specification or char expression in TRIM
ORA-26682: invalid value for publication_on
ORA-37010: (XSACQUIRE_DIFFAW) When using CONSITENT WITH clause, all objects must come from the same analytic workspace.
NID-00450: Succesfully changed database name and ID.
Oracle Errors 
