About Data Replication and Integration Features

It is not always possible for an organization to consolidate all of its data into a single database. The data might be spread over several geographic locations, and some remote locations might not have good connectivity with a primary site. In some cases, the data might be consolidated, but the organization might need a method for best of breed applications to communicate with each other. These are only a few reasons why organizations might need to share information between locations or applications.

Oracle Database provides several ways for organizations to achieve their data replication and integration goals. This topic helps you decide which data replication and integration features are best for your organization.

The following topics describe when to use different data replication and integration features:

• When to Access and Modify Information in Multiple Databases

• When to Replicate Data with Oracle Streams

• When to Replicate Data with Materialized Views

• When to Send Messages Between Databases

You can choose to use one of these features or a combination of them to meet your requirements.