Using add_schema_rules to Create an Apply process

RULE_CONDITION
--------------------------------------------------
((:ddl.get_object_owner () = 'NY2' or :ddl.get_base
_table_owner() = 'NY2') and :ddl.is_null_tag() = '
Y' and :ddl.get_source_database_name () = 'DNYTST10.WORLD' )

Next, the create_apply procedure that can be used to configure the Capture process will be introduced.

Using the create_apply Procedure to Create an Apply Process

This section will present another method by which an Apply process can be created. It allows the association of customized rules and rule sets that have already been created. For this, the create_apply procedure of the dbms_apply_adm package is used. When custom rule sets and rule conditions are designed, this method becomes the natural choice.

This method provides a flexible way to create a basic Apply process and then extend it to associate various apply handlers.

Figure 5.5 shows the parameters or arguments that can be passed on to execute the create_apply procedure.