How to setup Streams replication using DBMS_STREAMS_ADM.MAINTAIN_* set of procedures
Last updated on MAY 15, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.1.0.2 to 220.127.116.11 [Release 10.1 to 11.2]
Information in this document applies to any platform.
Checked and updated on 04-July-2013
This article provide a very fast method to setup streams environment, we will use set of scripts provided already under DBMS_STREAMS_ADM package, these scripts provides many levels of streams setup, like table level, schema level etc.
The following procedures are available :
Each one of the above procedures can be used to create a different level of streams environments. We will use dbms_streams_adm.MAINTAIN_TABLES in this article as an example, but all procedures uses almost the same information and the same guide lines.
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