Using add_subset_rules for Apply
Creation
include_tagged_lcr => false,
source_database => 'DNYTST10.world',
inclusion_rule => true);
END;
/
Prompt
(6) Now instantiate SCN
set serveroutput on
DECLARE
iscn NUMBER; -- Variable to hold instantiation SCN value
BEGIN
iscn := DBMS_FLASHBACK.GET_SYSTEM_CHANGE_NUMBER();
dbms_output.put_line ('Instantiation SCN : ' || iscn ) ;
DBMS_APPLY_ADM.SET_TABLE_INSTANTIATION_SCN@DNYOIP20.world (
source_object_name => 'ny3.allinsured1',
source_database_name => 'DNYTST10.world',
instantiation_scn => iscn
);
END;
/
Start the Capture and Apply processes at
the source and destination, respectively.
connect
strmadm/strmadm@dnyoip20
PROMPT (7) Starting the Apply Prcoess at destination DNYOIP20
begin
dbms_apply_adm.start_apply (apply_name => 'ln3_apply' ) ;
end ;
/