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_table_rules

Figure 5.3 gives a view of all the parameters that needed to pass to the add_table_rules procedure to create the Apply process. The procedure has two OUT variables, dml_rule_name and ddl_rule_name, to show the rules that are generated. The streams_type parameter needs to be specified as APPLY.

Figure 5.3 add_table_rules procedure parameters

 

In the add_table_rules procedure, various parameters provide necessary attributes as shown below:

  • include_dml: If TRUE, the procedure creates a DML rule for DML changes. If FALSE, the procedure does not create a DML rule. NULL is not permitted.
     

  • include_ddl: If TRUE, the procedure creates a DDL rule for DDL changes. If FALSE, the procedure does not create a DDL rule. NULL is not permitted.
     

  • include_tagged_lcr: If TRUE, no condition regarding Streams tags is added to the generated rules. Therefore, these rules can evaluate to TRUE regardless of whether a redo entry or LCR has a non-NULL tag.
     

  • inclusion_rule: If inclusion_rule is TRUE, the rules are added to the positive rule set for the Streams client. If inclusion_rule is FALSE, the rules are added to the negative rule set for the Streams client.

The following example will be used to illustrate the Apply creation process. The following SQL statement creates an Apply process named ln1_apply and defines rules for the table NY1.ALLINSURED1:

PROMPT ** Creating Apply Side Table rules at Destination(DNYOIP20)


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.