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.


Posted in DBA
Leave a Reply

Your email address will not be published. Required fields are marked *