 |
|
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.
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
refreshes are
made possible, in part, through the use of the
Materialized
View Log
(Materialized View
Log).
The Materialized View
log tracks all the changes that occur in the object that the
Materialized View
log is assigned.
Those changes (or deltas) are then applied to the remote
Materialized Views.
Here is an example of the creation of an Materialized View
log:
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
depot:
http://www.rampant-books.com/book_2003_2_replication.htm
|
|
|
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. |
|
|
