Oracle Error QSM-02191: types of MV logs are not compatible

Oracle Error Message

QSM-02191: types of MV logs are not compatible

Reason for the Error

The capability in question is not supported when the materialized view is defined on detail tables which do not have a compatible type of materialized view logs, either all timestamp based or commit SCN based.

Solution

Complete refresh or recreate materialized view logs.