To continue reading for free, register below or login
To read more you must become a member of SearchOracle.com
There are a number of options available for data replication; the main ones are:
- procedural calls to remote database to carry out DML
- simple MV replication
- Advance Replication where multiple nodes can be masters of the same objects
- Oracle Streams/Change Data Capture process
Specifically on 10g, there are more fast-refresh capabilities of materialized views. There is a new option in dbms_mview.refresh to force a partition refresh. Oracle 9i provided dbms_mview.explain_mview to explain if MV is fast-refreshable or eligible for query rewrite. 10g offers a new procedure in dbms_advisor.tune_mview to redefine MV to be fast-refreshable and or fix problems with MV logs which prevents MV from being fast-refreshed.
Additionally the CDC process has been enhanced so that you can capture changes synchronously or asynchronously. (See http://www.nyoug.org/lisigcdc.ppt.)
Regards,
Harish
|
