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

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


Free Oracle App Server Tips


Oracle support

Oracle training

Oracle tuning


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:

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.