QSM-01084: materialized view, string, has anchor, string,
not found in query
- 1 Answers
- 2592 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-02806: Unable to set handler for SIGALRM
RMAN-06553: DB_CREATE_FILE_DEST must be set for SET NEWNAME ... TO NEW
ORA-16108: database is no longer a standby database
ORA-13109: spatial table string exists
ORA-15073: diskgroup string is mounted by another ASM instance
ORA-02368: file string is not valid for this load operation
ORA-37084: Output valueset string must match string's dimesnionality
ORA-04045: errors during recompilation/revalidation of string.string
ORA-16121: applying transaction with commit SCN string
ORA-23305: internal deferred RPC error: string
RMAN-03036: Debugging set to level=number, types=string
ORA-13605: The specified task or object string does not exist for the current user.
Oracle Errors 
