Q

Data replication in 10g

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

How does Oracle 10g help with data replication in a distributed relational database architecture?
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 last published in September 2005

PRO+

Content

Find more PRO+ content and other member only offers, here.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

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

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close