ORA-12034: materialized view log on xx.xx younger than last refresh when a mview fast refresh after Impdp

  • 2013/05/10
  • ORACLE 9i-23ai
  • 2,263 views
  • ORA-12034: materialized view log on xx.xx younger than last refresh when a mview fast refresh after Impdp已关闭评论

ORA-12012: error on auto execute of job 88
ORA-12034: materialized view log on “TOPBOX”.”TOPBOX_COURSESTUDY” younger than last refresh
ORA-06512: at “SYS.DBMS_SNAPSHOT”, line 2256

,

阅读全文

materialized view exp imp(物化视图的导出导入)

物化视图的快速刷新要求基本必须建立物化视图日志，物化视图日志的名称为MLOG$_加表名称，如果对象已经存在为在日志名称后加数字序列如mlog$_test1，下面就测试一把物化视图的导入导出

阅读全文