ORA-12034 Materialized View Log Younger Than Last Refresh
We have got a distributed environment and the DB version is:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
Recently there was a change in the base table at the master site,that change basically includes an addition of couple of new columns in the base table. Now at the Target DB we have a Materialized view which get refreshed and the refresh type is set as Fast.
Since this change has taken place the Fast refresh type is getting failed throwing an ORA-12034 error.
Though the MV Log was recreated at the Source DB/master site and after that we did a complete refresh.Complete Refresh was successfull but still we are unable to use Fast Refresh using DBMS_SNAPSHOT.REFRESH .
Again the new columns that has been added we have not included those columns in our MV on the target DB/remote site.
Prior to this change everything was working fine.
Need your kind help to resolve this particular problem.
Thanks in advance.
--Vineet