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

Oracle Error Message

QSM-01081: no primary key or row id found for table, string, in MV, 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