||Oracle Replication Tips by Burleson
Updating Oracle Materialized View Data
Causes the entire Materialized View to
be refreshed, rather than just specific row changes.
The Materialized View will be truncated
and then repopulated. This implies that it will become
unavailable for a period of time.
Causes a fast refresh to occur if that
is possible. If a fast refresh is not possible, then a
complete refresh will be performed.
This option avoids replication failures
if the source table should not be fast refreshable.
is scheduled for replication, a related job is created in the Oracle
job scheduler. You can see this job when you issue this query:
Select job, what, failures from dba_jobs where what like ’%dbms_refresh%’;
You should ensure that the job scheduler is properly configured.
Specifically, you need to ensure that the
This is an
excerpt from Oracle Replication By Rampant TechPress (only $19.95).
You can click here to order a copy and get instant access to the code
Get a Personal Oracle
The author is now offering personal mentors for
Oracle DBAs where you can have an Oracle expert right at your
fingertips, anytime day or night. We work with hundreds of Oracle
databases every year, so we know exactly how to quickly assist you
with any Oracle replication question.
You can get me personally, or any Oracle Certified replication DBA
with more than 20 years of full-time IT experience.