My Oracle Support Banner

Hub and Spoke Streams Replication Setup between 3 Databases (Doc ID 462102.1)

Last updated on AUGUST 31, 2023

Applies to:

Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.
Oracle Server Enterprise Edition - Version: to


Hub-n-Spoke replication has typically a single Hub database to which all the other Spoke databases will be replicating. The changes (DML & DDL) originated on the Hub will be replicated to all the Spoke databases. The changes made by any other databases will replicate to Hub and Hub will replicate these changes to all other Spokes except the Spoke where change is originated. 

The Sample Code performs Streams Replication between  three databases on a schema level. The changes (DML & DDL) from any one of these database will replicate to the other two databases.

The following is Description of Streams Replication Setup:


All the databases are running on 10gR2 (code is tested on 


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

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

In this Document
 Sample Code
 Sample Output

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