...
- Unprepare the table to remove it from the replication
- Shutdown or pause the Apply APPLY process. This to ensure that the current transactions on the table will not happen before the historical data is reloaded and cause further conflicts
- Prepare the table and add it back in the replication. Dbvisit Replicate will issue an SCN number to the console. This SCN number will be used to create the starting point
- Truncate the table on target
- Use an external method to load the historical data using the SCN so that both source and target tables will be in sync as of the specified SCN. If Oracle datapump is used then the flashback_scn can be used.
...