Oracle Error QSM-02126: no rowid at master site

Oracle Error Message

QSM-02126: no rowid at master site

Reason for the Error

The capability in question is not supported when the materialized view references a remote site that does not support rowids.

Solution

Re-phrase the query to avoid the reference to the remote site.