How To Setup Refresh Ggroup and Collect Information About It
(Doc ID 1346461.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Server - Enterprise Edition - Version: 184.108.40.206 to 220.127.116.11 - Release: 8.0.6 to 11.2
Information in this document applies to any platform.
The goal intended on this note is complement to <
Testing has been done on a 11.2 database, but most of the queries are quite similar in older and newer releases.
Because materialized view refresh is set-based, if you require that two or more materialized views be refreshed to a single point in time, a materialized view refresh group will need to be created.
Oracle guarantees that data integrity will be kept once the group refresh is completed, but we can't guarantee the order on what the mviews will be refreshed.
For example, to preserve a master-detail relationship between a pair of materialized views, place the related materialized views in the same refresh group.
Creating constraints to preserve the integrity is not recommended, as that may cause errors to be raised if detail mview is refreshed before master.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!