Setting SCN Values for an Existing Capture Process

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.

Capture 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, respectively.

Figure 4.8 shows the add_subset_rules procedure arguments that can be used to create the Capture process.

Figure 4.8 Parameters for add_subset_rules procedure