【IT专家】创建Oracle物化视图,每5分钟刷新一次使用物化视图日志

视图日志

本文由我司收集整编，推荐下载，如有疑问，请与我司联系创建Oracle物化视图，每5分钟刷新一次使用物化视图日志创建Oracle物化视图，每5分钟刷新一次使用物化视图日志[英]Create Oracle Materialized View to be refreshed every 5 minute Using materialized view log I’m Trying to create Materialized View which will be updated every 5 minute automatically, I need update based on Mview log table.

我正在尝试创建物化视图,它将每5分钟自动更新一次,我需要基于Mview日志表进行更新。

I have created Materialized view log on TABLE1 TABLE1.SQL Script

我在TABLE1 TABLE1.SQL脚本上创建了Materialized视图日志 CREATE MATERIALIZED VIEW LOG ON TABLE1; -- MLOG$_TABLE1 Then I’ve created Materialized View

然后我创建了物化视图

CREATE MATERIALIZED VIEW JIBO_MVIEW REFRESH START WITH SYSDATE NEXT SYSDATE +5/24/60 ENABLE QUERY REWRITE

AS

SELECT

O.ID ,O.DATETIME_CREATED ,O.ORIGINATOR ,O.DETAILS ,O.PAYMENT_REF FROM TABLE1 O WHERE O.ORIGINATOR LIKE ‘53%’; after changing some value In TABLE1, new Record is inserted MLOG$_TABLE1 log table

更改一些值后在TABLE1中,新的Record插入了MLOG $ _TABLE1日志表

but changed value is not updated in Materialized view (JIBO_MVIEW). (even after one day :) )

但在物化视图(JIBO_MVIEW)中未更新更改的值。(纵然一天后:)) As I checked in Alert Log there is problem with auto generated DBMS_JOB, it fails on every executions.

当我检查警报日志时,自动生成的DBMS_JOB存在问题,每次执行都会失败。

- ORA-12012: error on auto execute of job 4263 - ORA-00942: table or view does not