ORA-12034 materialized view log on younger than last refresh

Hi all, if you encounter ORA-12034 error. It means, a complete refresh is required before the next fast refresh. So, I run the code below in order to make a complete refresh.


DBMS_MVIEW is a synonym for DBMS_SNAPSHOT.


According to the Oracle Docs, the second parameter of DBMS_MVIEW.REFRESH method is refer to four different parameters. An f indicates fast refresh. ? indicated force refresh which means Oracle tries to make a fast refresh if this is not possible then make complete refresh. C or c indicates complete refresh. A or a indicates always refresh. A are C are equilavent.


DBMS_MVIEW.REFRESH('MV_NAME', 'c');


Posted in DBA
Leave a Reply

Your email address will not be published.