Oracle Error QSM-01092: mjv tries to rewrite a semi-join and primary key or rowid missing

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