9i: How To Setup Oracle streams replication.
(Doc ID 224255.1)
Last updated on MARCH 15, 2021
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 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 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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!