Oracle Error Message
QSM-01092: mjv tries to rewrite a semi-join and primary key or rowid missing
Reason for the Error
Materialized join view tries to rewrite a semi-join (IN sub-query) and the primary keys or rowids of left tables of semi-joins are missing from MJV.
Solution
None