Creation of Propagation Process

The create_propagation procedure creates a propagation, but it does not create rules or a rule set for the propagation. The create_propagation procedure enables the specification of an existing rule set that can be associated with the propagation, either as a positive or a negative rule set. All propagations are started automatically upon creation. Creation of propagation in this manner gives a manual yet flexible method for administration.

The next section will present details on the creation of the Propagation process.

Using add_table_propagation_rules

The add_table_propagation_rules procedure is most often used for configuring a table level propagation. It is fairly simple to use and it creates rule sets and rules automatically.

This procedure adds table rules to the positive or negative rule set for a propagation.  It will create the specified propagation if it does not exist.

Figure 4.11 shows the parameters that the DBA can specify for the procedure.

Figure 4.11 Parameters for add_table_propagation_rules

 

The following is an example that runs the add_table_propagation_rules procedure in the dbms_streams_adm package to create a propagation:

BEGIN
DBMS_STREAMS_ADM.ADD_TABLE_PROPAGATION_RULES(