My Oracle Support Banner

How to setup Streams Schema level replication using MAINTAIN_SCHEMAS procedure (Doc ID 878638.1)

Last updated on FEBRUARY 02, 2024

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.1 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
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 Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.


This article provide the steps needed to setup Schema Level streams environment, we will use set of scripts provided already under DBMS_STREAMS_ADM package .

 This procedure configures a Streams environment that replicates changes to specified schemas between two databases. This procedure can either configure the environment directly, or it can generate a script that can be edited and used to configures the environment later.

Notice this procedure should run at the capture database. The capture database is the database that captures changes made to the source database.

This procedure is overloaded. so the schema_names parameter can provided in type of VARCHAR2 or also in type of  DBMS_UTILITY.UNCL_ARRAY. These parameters enable you to enter the list of schemas in different ways and are mutually exclusive.



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

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