When this error happens, are the only solutions to do either
1. a complete refresh
2. drop MV, drop Mlog on master side, create Mlog on master side, recreate the MV from scratch
Can something else be done to avoid #1, or #2?
The MV has not been refresh for over a year.
This error happens when I tried to do a fast refresh.
exec DBMS_SNAPSHOT.REFRESH('myMV,'f');