How to setup Streams Schema level replication using MAINTAIN_SCHEMAS procedure
Last updated on FEBRUARY 08, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 126.96.36.199 [Release 10.1 to 11.2]
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms