Oracle Solution for Error ora-12097
ORA-12097: changes in the master tables during refresh, try refresh again
What triggered the Error:
There are some changes (i.e., conventional DML, direct load, partition maintenance operation) in the master tables during materialized view refresh.What should we do to fix it:
Refresh the affected materialized views again.
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
