||Oracle Replication Tips by Burleson
Oracle Materialized View Replication
value of OKC. This allows us to restrict the data that is
available to other systems that might be using your
Materialized View Logs
Some methods of replication involve the application of only the
changes that apply to a given Materialized View.
This is known as a fast refresh
(and we will discuss fast refreshes in more detail shortly) Fast
made possible, in part, through the use of the
The Materialized View
log tracks all the changes that occur in the object that the
log is assigned.
Those changes (or deltas) are then applied to the remote
Here is an example of the creation of an Materialized View
Create materialized view log on table parts;
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
||Need an Oracle Health Check?
Does your boss blame you for an Oracle performance problem?
Need to prove that your database is properly optimized?
BC Oracle performance guru's can quickly verify every aspect of your
Oracle database and provide a complete certification that your database
is fully optimized.