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');