===============
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