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

    Requires Free Membership to View

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


This was first published in September 2005

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: