Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-01049: semi-join check failed for materialized view, string
- 1 Answers
- 2701 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: If there is a semi join in the query, then Query
Rewrite will create (select distinct <pk-list>, <ref-col>
from mjv) where <pk-list> is the list of rowids/pk of all
mjv tables that don't correspond to a right side of a
semi-join and <ref-col> are their columns. Query Rewrite
will not occur if a join from the materialized view cannot
match the semi-join from the query.
Action: none
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
LCD-00210: illegal assignment operator [string]
TNS-01412: Handler(s):
ORA-18015: invalid source outline signature
TNS-00266: Navigator: Unknown Request
LPX-00232: invalid use of a parameter entity reference
ORA-22859: invalid modification of columns
ORA-22869: depth of type dependency hierarchy exceeds maximum limit
ORA-24196: access the message in a wrong access mode
ORA-15109: conflicting protection attributes specified
ORA-06322: IPA: Fatal shared memory error
EXP-00070: attempt to free unallocated memory
ORA-25464: ROWID not specified for table alias: string
Oracle Errors 
