My Oracle Support Banner

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

Last updated on MARCH 15, 2021

Applies to:

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

Purpose

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.

Scope

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 V920.IDC.ORACLE.COM
The Global Database Name of the Destination Database is TEST920.IDC.ORACLE.COM
In the example setup, DEPT table belonging to SCOTT schema has been used for
demonstration purpose.

Details

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.