Oracle DBA, How To, Error, Cause and Action

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

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


Cause:


There are some changes (i.e., conventional DML, direct load, partition maintenance operation) in the master tables during materialized view refresh.



Action:


Refresh the affected materialized views again.

No comments:

Post a Comment

Thanks for your comment.