How to setup Streams Schema level replication using MAINTAIN_SCHEMAS procedure
(Doc ID 878638.1)
Last updated on AUGUST 31, 2021
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 184.108.40.206 [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.
Article-ID: <Note 864973.1>
Title: How to setup Streams replication using DBMS_STREAMS_ADM.MAINTAIN_* set of procedures
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