Oracle Error QSM-01105: no primary key or row id in MV, string, is found for table, string

Oracle Error Message

QSM-01105: no primary key or row id in MV, string, is found for table, string

Reason for the Error

In order to obtain a missing column, the materialized view needs to join back to the above table. But it lacks the primary key or rowid for the table.

Solution

None