Capture Creation – Using add_global_rules procedure

 include_ddl                  IN BOOLEAN DEFAULT false,
 include_tagged_lcr      IN BOOLEAN DEFAULT false,
 source_database                      IN VARCHAR2 DEFAULT NULL,
 dml_rule_name                         OUT VARCHAR2,
 ddl_rule_name                         OUT VARCHAR2,
 inclusion_rule               IN BOOLEAN DEFAULT true,
 and_condition             IN VARCHAR2 DEFAULT NULL);

In order to copy the source database initially, the RMAN DUPLICATE command can be used to instantiate the source database at the destination database. The UNTIL SCN clause can be used to specify an SCN for the duplication.

Once the destination database has been created successfully, the Streams configuration at the destination must be removed in order to facilitate a fresh configuration. The remove_streams_configuration() procedure of the package dbms_streams_adm can be used to accomplish this.