Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-01084: materialized view, string, has anchor, string,
not found in query
- 1 Answers
- 2854 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-19853: error preparing auxiliary instance string (error string)
RMAN-05503: at least one auxiliary channel must be allocated to execute this command
ORA-16753: Resource guard could not open standby database
PLS-00587: a static method cannot be invoked on an instance value
ORA-28029: could not authorize remote server for user string
RMAN-06514: archived logs required to recover from this copy will not be kept
ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
TNS-00008: INTCTL: could not contact destination Navigator
ORA-01531: a database already open by the instance
LPX-00120: entity "~1S" NDATA (notation) "~2S" is undefined
RMAN-06067: RECOVER DATABASE required with a backup or created controlfile
ORA-39117: Type needed to create table is not included in this operation. Failing sql is: string
Oracle Errors 
