Capture Creation – Using create_capture procedure

• For the first_scn, the lowest SCN in the redo log from which a Capture process can capture changes is specified. A non-NULL value for this parameter is valid only if the dbms_capture_adm.build procedure has been run at least once at the source database.
   

• The logfile_assignment parameter is relevant for Down Streams capture configuration. If set to IMPLICIT, which is the default, the Capture process at a Down Streams database scans all redo log files added by log transport services or manually from the source database to the Down Streams database. If set to EXPLICIT, a redo log file is scanned by a Capture process at a Down Streams database only if the Capture process name is specified in the for logminer_session_name clause when the redo log file is added manually to the Down Streams database.

The following section presents an example that is used to illustrate the local capture creation using the create_capture procedure.

The first step is to create the rule set and add a rule to the rule set. For creating the rule, the create_rule procedure can be used.  For creating the rule set, the create_rule_set procedure of the dbms_rule_adm package can be used. The following SQL creates a rule, a rule set and adds the rule to the rule set.

--(1) First Create Rule Set
BEGIN
DBMS_RULE_ADM.CREATE_RULE_SET(
 rule_set_name                         => 'strmadm.ny4_set1',
 evaluation_context        => 'SYS.STREAMS$_EVALUATION_CONTEXT');
END;
/
-- (2) Then Create a Rule
BEGIN
DBMS_RULE_ADM.CREATE_RULE(