QSM-01084: materialized view, string, has anchor, string,
not found in query
- 1 Answers
- 2562 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-19020: invalid dereference of XMLType columns
QSM-02127: not supported for this type mv by Oracle version at master site
PCB-00008: Must use option SQLCHECK=SEMANTICS(FULL) when there is embedded PL/SQL
ORA-31612: Allocation of process descriptor failed.
PLS-00434: record field has unsupported type: "string"
DRG-11410: could not insert into string result table
TNS-00008: INTCTL: could not contact destination Navigator
ORA-16162: Cannot add new standby databases to protected configuration
NNL-00001: request argument "string" is invalid
PLS-00496: too few columns in SELECT...INTO statement after bursting record targets
NNC-00406: name "string" does not exist
ORA-17612: Failed to discover Oracle Disk Manager library, return value string
Oracle Errors 
