Materialized view demanding complete refresh
I am having a problem with one of my Oracle 11g R2 database. I have two other oracle servers that pulls data from this database using mviews. the problem is that when I create mview of same table on both database, i am not able to fast refresh my mviews. only the latest created mview gets fast refresh but the other one start giving "Materialized View Log Younger Then Last Referesh". if I do a complete refresh for the first mview then the other one starts giving this error.
i.e. i tried following commands
On DB1
Create Materialized View Log On Base_Table