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

Home
Corporate Oracle Training
Custom Oracle Training
Oracle New Features Training
Advanced Oracle DBA Classes
Oracle Tuning Courses
Oracle Tips & Tricks
Oracle Training Links
Oracle Training Links
Oracle Training Links

We are top for USA Oracle Training Clients

 

Free Oracle Tips


 
HTML Text AOL

Free Oracle App Server Tips


 
HTML Text

Oracle support

Oracle training

Oracle tuning

Rednecks!

Remote Oracle

Custom Oracle Training

 

   
  Oracle Tips by Burleson

Oracle Streams
Chapter 5 -
Apply Process Configuration

Using add_subset_rules for Apply Creation

This method is a variation of the add_table_rules method where DML conditions can be added. For example, to a particular destination, the goal is to apply only a specific set of rows based on a WHERE clause type condition. Based on some attribute within a row, the DBA may chose to replicate only some subset of the data. This procedure helps specify the where clause type condition.

Figure 5.4 shows the signature and the arguments for the add_subset_rules procedure. The argument dml_condition specifies the where clause type condition which basically sets the filter condition.

Figure 5.4 add_subset_rules procedure parameters

 

This will be illustrated by an example. The example begins with the table named ALLINSURED1 which is residing in schema NY3. The usual capture and propagation will be configured at the source database. At the destination database, the add_subset_rules procedure will be used and the DBA will specify the DML condition.

The configuration process follows the following steps.

  1. Create the queue at the source database using set_up_queue.
     

  2. Create the Capture process at the source database using add_table_rules.
     

  3. Create the queue at the destination database using set_up_queue
     

  4. Create the Apply process using add_subset_rules.
     

  5. Create the propagation process using add_table_propagation_rules.


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 performance tuning book

 

 

Oracle performance tuning software

 
Oracle performance tuning software
 
Oracle performance Tuning 10g reference poster
 
Oracle training in Linux commands
 
Oracle training Excel
 
 
 
 

 

email BC:


Copyright © 1996 -  2014 by Burleson Inc. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.