Setting the starting point

Owned by Copy Space for Confluence
Sept 24, 2015
1 min read

When Dbvisit Replicate prepares a table for replication it captures the SCN of the Oracle database to record the starting point. This is done through the prepare statement. The prepare statement does not start the replication, but initiates the following:

1. Marks the table on MINE to be mined.

2. Sets the conflict handlers.

3. Records the SCN (or sets the starting point - in some terminology this is called instantiation). When the actual replication begins (through the start MINE command), it will start mining (or replicating) from this SCN for the table.