向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');
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)