ORA-12034:视图日志比上次刷新后的内容新

向LCM_DICTIONARY插入数据报错
ORA-12034: "LCM"."LCM_DICTIONARY"上的实体视图日志比上次刷新后的内容新
这是物化视图的问题,先通过下列方式找到物化视图:
USER_MVIEWS
SELECT mview_name, last_refresh_date, fullrefreshtim, increfreshtim
  FROM dba_mview_analysis;
select * from user_objects where object_type='MATERIALIZED VIEW';

然后对物化视图进行刷新:
exec dbms_mview.refresh('MV_BUREAU_TABLE','C'); 

exec dbms_mview.refresh('MV_BUREAU_TABLE'); 


metalink上有相关的文章:Diagnosing ORA-12034 Materialized View Log Younger Than Last Refresh (Doc ID 204127.1)

你可能感兴趣的