ORA-12034: materialized view log on “TEST”.”tab01″ younger than last refresh

Symptoms:

SQL> SELECT job, what mview_name, TO_CHAR (last_date, ‘mm/dd/yyyy hh24:mi:ss’) last_execution,
TO_CHAR (next_date, ‘mm/dd/yyyy hh24:mi:ss’) next_execution, INTERVAL
FROM dba_jobs WHERE what LIKE ‘dbms_refresh.refresh%’ ;
JOB MVIEW_NAME LAST_EXECUTION NEXT_EXECUTION INTERVAL
207 dbms_refresh.refresh(‘”TEST”.”TST_REFRESH_GROUP”‘); 01/01/4000 00:00:00 trunc(add_months(sysdate,12))

ORA-12048: error encountered while refreshing materialized view “TEST”.”Test_MV”
ORA-06512: at line 35
ORA-06512: at “SYS.DBMS_SNAPSHOT_KKXRCA”, line 3012
ORA-12034: materialized view log on “TEST”.”tab01″ younger than last refresh
ORA-06512: at “SYS.DBMS_SNAPSHOT_KKXRCA”, line 88
ORA-06512: at “SYS.DBMS_SNAPSHOT_KKXRCA”, line 253
ORA-06512: at “SYS.DBMS_SNAPSHOT_KKXRCA”, line 1273
ORA-06512: at “SYS.DBMS_SNAPSHOT_KKXRCA”, line 2468
ORA-06512: at “SYS.DBMS_SNAPSHOT_KKXRCA”, line 2968
ORA-06512: at “SYS.DBMS_SNAPSHOT_KKXRCA”, line 3255
ORA-06512: at “SYS.DBMS_SNAPSHOT_KKXRCA”, line 3314
ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 44
ORA-06512: at “SYS.DBMS_IREFRESH”, line 1177
ORA-06512: at “SYS.DBMS_REFRESH”, line 263
ORA-06512: at line 10

Solution:

DROP MATERIALIZED VIEW LOG ON tab01;

DROP MATERIALIZED VIEW Test_MV;

Leave a Reply

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