ORA-12034: materialized view log on "SCOTT"."T_ROWID" younger than last refresh

往一张物化视图基表插入一条数据时报：

ORA-12034: materialized view log on "SCOTT"."T_ROWID" younger than last refresh

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2563

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2776

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2745

ORA-06512: at line 2

解决方法:

SQL> exec dbms_mview.refresh('MV_T_ROWID');

begin dbms_mview.refresh('MV_T_ROWID'); end;

ORA-12034: materialized view log on "SCOTT"."T_ROWID" younger than last refresh

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2563

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2776

ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2745

ORA-06512: at line 2

使用完全刷新：

SQL> exec dbms_mview.refresh('MV_T_ROWID','C');

PL/SQL procedure successfully completed

再次往物化视图基表成功插入数据。