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


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


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