How does Oracle 10g help with data replication in a distributed relational database architecture?

    Requires Free Membership to View

    Login

There are a number of options available for data replication; the main ones are:

  1. procedural calls to remote database to carry out DML
  2. simple MV replication
  3. Advance Replication where multiple nodes can be masters of the same objects
  4. 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

This was first published in September 2005

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top