 |
|
Oracle Tips by Burleson |
Oracle Streams
Chapter 5 -
Apply Process Configuration
Using the create_apply Procedure to
Create an Apply Process
In this method, rules and rule sets are created
prior to creating the Apply process. Rules are added to the rule
set. Then, the rules are associated with the Steams client Apply
process.
In the following example, the Capture process
will be created using the add_table_rules procedure and the
propagate process using the add_table_propagation_rules
procedure. In case of the Apply Process, the create_apply
procedure will be used.
Before the Apply process is created, the rule
set will be created and a rule added to the rule set. It will have
these three steps:
-
For creating the rule, the create_rule
procedure will be used.
-
For creating the rule set, the create_rule_set
procedure of dbms_rule_adm package can be
used.
-
The rule set will be specified as a parameter
to the create_apply procedure.
Streams_config.sql, which is available
in the code depot, lists SQL statements that display details of the
configuration of the Streams clients:
The next step is to load records at the source
database table by using the script load_ny4_allinsured1.sql
which can be found in the code depot.
The above text is
an excerpt from:
Oracle Streams
High Speed Replication and Data
Sharing
ISBN 0-9745993-5-2
by Madhu Tumma
 |
For more details and scripts, see my new book "
Oracle
Tuning: The Definitive Reference", over 900 pages
of BC's favorite tuning tips & scripts.
You can buy it direct from the publisher for 30%-off and get
instant access to the code depot. |
|
