- 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.)
Dig Deeper on Oracle SOA
Related Q&A from Harish Harbham
SOA and Integration expert Harish Harbham explains how to transfer data from Oracle to MS SQL Server. Continue Reading
Oracle expert Harish Harbham explains how Oracle Streams can be used for replication. Continue Reading
Expert Harish Harbham answers the question, "How do you convert SQL Server 2005 database into 0racle 10g?" Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.