- 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.)
This was first published in September 2005