Oracle Error QSM-01281: query rewrite not possible because either a primary key or a row id is required to join table string with MV string

Oracle Error Message

QSM-01281: query rewrite not possible because either a primary key or a row id is required to join table string with 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