Oracle Error QSM-02073: non-primary key RepAPI mv is not fast refreshable

Oracle Error Message

QSM-02073: non-primary key RepAPI mv is not fast refreshable

Reason for the Error

Fast refresh is supported for RepAPI materialized views only if it is also a primary key materialized view.

Solution

Re-design the materialized view to be a primary key materialized view.