Capture Creation – Using create_capture procedure

On the down side, it requires more manual creation of necessary rules and rules sets. Since much of the work is manual, it requires careful planning.

Figure 4.10 shows the list of arguments for the create_capture procedure.

Figure 4.10 Parameters for the create_capture procedure

 

The following guidelines are used for running the create_capture procedure:

• The name of the positive rule set which already exists must be specified. The positive rule set contains the rules that instruct the Capture process to capture changes. The rule set should be specified as [SCHEMA_NAME.]RULE_SET_NAME. If the schema is not specified, the current user is the default.
   

• A rule set can be created and rules added to it using the dbms_streams_adm package or the dbms_rule_adm package prior to running this procedure.
   

• For start_scn, a valid SCN must be specified for the database from which the Capture process should start capturing changes. If the specified value is lower than the current_scn of the source database, either the first_scn should be specified or the SCN value specified for start_scnmust be greater than or equal to the first_scn of an existing Capture process which has taken at least one checkpoint.
   

• If the start_scn is NULL and no value is specified for the first_scn, the database's current_scn is used as the start_scn. If the start_scn is NULL and first_scn is non-NULL, the First_SCN value is used. If a value is specified for both the start_scn and the first_scn, the start_scn value must be greater than or equal to the first_scn value. An error is returned if an invalid SCN is specified.