Anything else we have to do to make this configuration smooth ?
1. Shouldn't we be leaving the extract at the source running so that it will capture the changes during these 2 hours ? 2. What about the secondary extract (Pump) in source. Should it be running ? 3. Replicat in the Target should be stopped during this period of 2 hours. Right ?
You mean I have to get the SCN of the source using either of the below queries just before I start the expdp of the source tables ?
start replicat <rep_name>, aftercsn <SCN#>
select current_scn from v$database; or select dbms_flashback.get_system_change_number() from dual;