Pages

Wednesday, March 16, 2022

ORA-32321: REFRESH FAST unsupported after detail table TRUNCATE; ORA-12034: materialized view log younger than last refresh

===============
Issue
===============
BEGIN
 DBMS_REFRESH.REFRESH('MY_USER.GSM_COUNTRIES');
END;
/

ORA-32321: REFRESH FAST of "MY_USER"."GSM_COUNTRIES" unsupported after detail table TRUNCATE
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2809
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3025
ORA-06512: at "SYS.DBMS_IREFRESH", line 689
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 2
or
ORA-12034: materialized view log on "NPPROV"."GSM_REGIONS" younger than last refresh
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2809
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3025
ORA-06512: at "SYS.DBMS_IREFRESH", line 689
ORA-06512: at "SYS.DBMS_REFRESH", line 195
ORA-06512: at line 2



===============
Solution
===============
C - Stands for Complete

BEGIN
 DBMS_MVIEW.REFRESH('MY_USER.GSM_COUNTRIES','C');
END;
/
PL/SQL procedure successfully completed.

BEGIN
 DBMS_REFRESH.REFRESH('MY_USER.GSM_COUNTRIES');
END;
/
PL/SQL procedure successfully completed.




No comments:

Post a Comment