Setting SCN Values for an Existing
So far, the creation of the Capture process
through the add_table_rules procedure has been presented.
The following section presents the creation of the Capture
process by other procedures.
Creation - Using add_subset_rules
The add_subset_rules procedure adds
rules whose rule condition evaluates to TRUE for DML changes
made to a subset of rows in a specified table.
This procedure creates the specified
Capture process if it does not exist. Running this procedure
generates three rules for the specified Capture process; one for
INSERT statements; one for UPDATE statements; and one for DELETE
statements. For INSERT and DELETE statements, only DML changes
that satisfy the condition specified for the dml_condition
parameter are captured, applied, or dequeued.
How does this help? This procedure helps
configure the part of the table for data replication.
Note : The add_subset_rules
procedure can also create an Apply process or messaging client
when the streams_type is specified as APPLY and DEQUEUE,
Figure 4.8 shows the add_subset_rules
procedure arguments that can be used to create the Capture
Figure 4.8 Parameters for