2023年11月26日发(作者：)

【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

Script

我在TABLE1 脚本上创建了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

,ME_CREATED ,ATOR ,S ,

MENT_REF FROM TABLE1 O WHERE ATOR 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