ORA-12097

Error: ORA-12097: changes in the master tables during refresh, try refresh again

Causa: There are some changes (that is, conventional DML, direct load, partition maintenance operation) in the master tables during materialized view refresh.

Acción: Refresh the affected materialized views again.