Skip to Main Content
  • Questions
  • Implicit Materialized View Fast Refresh

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question.

Asked: March 26, 2017 - 4:34 pm UTC

Last updated: March 27, 2017 - 7:21 am UTC

Version: 11G

Viewed 1000+ times

You Asked

Hi,

Is there any way by which we can fast refresh a materialized view implicitly without using refresh explicitly.

Thanks In Advance

and Connor said...

Check out 'on commit' refresh, which will do it for every transaction.

https://docs.oracle.com/cd/E11882_01/server.112/e25554/basicmv.htm#DWHSG8197

But why is there such a drama with an explicit refresh ? Just schedule a background job with DBMS_SCHEDULER and forget about it :-)



Is this answer out of date? If it is, please let us know via a Comment

More to Explore

DBMS_SCHEDULER

More on PL/SQL routine DBMS_SCHEDULER here