QSM-01049: semi-join check failed for materialized view, string
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 |
ORA-36954: (XSFCAST24) The cycle number must be between 1 and number. You specified number.
ORA-25425: connection lost during rollback
PLS-00551: character set ANY_CS is only allowed on a subprogram parameter
ORA-31218: DBMS_LDAP: PL/SQL - Invalid LDAP deleteoldrdn.
ORA-01624: log string needed for crash recovery of instance string (thread string)
ORA-02402: PLAN_TABLE not found
ORA-34021: (MSCGADD04) You must specify a partition when maintaining PARTITION TEMPLATE workspace object.
ORA-16067: activation identifier mismatch in archive log string
DRG-11102: assigned lexer can not operate on string language setting
DRG-11811: Multiple Choices
NNL-00521: Shows or sets the server's system query forwarding requirements
NZE-28832: invalid data unit format