Chapter 2. Using Oracle Streams

Replicating data undoubtedly is the most common application of Oracle Streams. Because of its capability to transform the replicated data and its flexibility that enables administrators to customize the information flow, Streams is useful in addressing a number of business requirements.

One of the key benefits of Oracle Streams is that it can replicate data between different hardware platforms and Oracle database versions. This powerful feature enables you to migrate databases across hardware platforms with little or no downtime and no data loss. It also facilitates database, platform, and application upgrades without downtime.