Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-01049: semi-join check failed for materialized view, string
- 1 Answers
- 2755 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 |
RMAN-06189: current DBID number does not match target mounted database (number)
ORA-31467: no column found in the source table
DRG-11857: Server Timed Out
TNS-01202: Missing the dba group (string) specified by DBA_GROUP in SID_DESC
LSX-00160: invalid substitution group affiliation between "~S" and "~S"
ORA-09757: osnipn: port allocation failure.
ORA-06907: CMX: error during connect confirmation
ORA-38487: FUNCTION/PACKAGE/TYPE "string" not allowed in the expression
ORA-14409: inserted partition key is outside specified subpartition
ORA-25158: Cannot specify RELY for foreign key if the associated primary key is NORELY
ORA-16800: Log transport service for some database is incorrectly set to ALTERNATE.
SQL*Loader-00409: Number to skip must be table-level, not load-level on continued loads
Oracle Errors 
