My Oracle Support Banner

9i: How To Setup Oracle streams replication. (Doc ID 224255.1)

Last updated on OCTOBER 05, 2021

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


Oracle Streams enables the sharing of data and events in a data stream, either
within a database or from one database to another.
This article is intended to assist Replication DBAs in setting up and
configuring Oracle Streams Replication.


To be used by Oracle support analysts and replication DBAs to setup replication
using Streams in Oracle 9.2.x.
This article discusses the steps to setup Streams Replication from one Oracle
database to another.
The Global Database Name of the Source Database is DBNAME1.REGION.EXAMPLE.COM
The Global Database Name of the Destination Database is DBNAME2.REGION.EXAMPLE.COM
In the example setup, <tabename> belonging to <schema> schema has been used for
demonstration purpose.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.