Call (800) 766-1884 for Oracle support & training
Free Oracle Tips

Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance
 

Free Oracle Tips


 

HTML Text

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Redneck
 

 

   
  Oracle Tips by Burleson

Oracle Streams
Chapter 4 - Capture and Propagate Configuration

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.


The above text is an excerpt from:

Oracle Streams
High Speed Replication and Data Sharing

ISBN 0-9745993-5-2

by Madhu Tumma
 


Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA






Oracle reference poster 




Rampant Oracle books     

 

   

Copyright © 1996 -  2009 by Burleson Enterprises, Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.