Capture Creation – Using create_capture procedure

rule_name => 'strmadm.ny4_rule1_dml',
condition => ' :dml.get_object_owner () = ''NY4'' AND ' || '
:dml.is_null_tag() = ''Y'' '
);
END;
/
-- (3) Add the rules to the rule set

BEGIN
DBMS_RULE_ADM.ADD_RULE(
rule_name => 'strmadm.ny4_rule1_dml',
rule_set_name => 'strmadm.ny4_set1');
END;
/

The next example shows how the create_capture procedure in the dbms_capture_adm package is used to create a local Capture process.  It uses the rule set that was created in the previous step.

BEGIN
DBMS_CAPTURE_ADM.CREATE_CAPTURE(
queue_name                 => 'ny4_queue',
capture_name               => 'ny4_capture',
rule_set_name             => 'strmadm.ny4_set1',
start_scn                       => NULL,
source_database          => NULL,
use_database_link        => false,
first_scn                        => NULL);
END;
/