My Oracle Support Banner

How to Avoid Long Refresh Time Required to Initialize Materialized View Data? (Doc ID 734596.1)

Last updated on OCTOBER 11, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2 to 10.2]
Information in this document applies to any platform.
***Checked for relevance on 19-Aug-2010***


The aim of this document is to discuss one of most simple and quick methods to initialize fast refresh materialized view data and avoid first complete refresh time

This method should help in case of having very large master tables.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.