Syncing one table with the Prepare and Load command

Problem Description

This article explains how to add a new table to replication and also load the table with the Dbvisit Replicate LOAD utility. How the data will be instantiated using the Load functionality is discussed in: https://dbvisit.atlassian.net/wiki/spaces/ugd9/pages/128742776/Load

Solution

Note: This refers to the 2.8 version of Replicate.

On the SOURCE database make sure that the dbvrep schema has the proper permissions on the table to be loaded:

SQL> GRANT SELECT ON SCOTT.REPTEST3 TO DBVREP;
SQL> GRANT FLASHBACK ON SCOTT.REPTEST3 TO DBVREP;

Create the table on the target database:

create table reptest3 (
  id number(8), 
  flag varchar2(4),primary key (id)
  );

Pause the MINE process:

dbvrep> pause MINE
      Mine requested to pause.

Run the command to Prepare and Load the table:

Resume the MINE process: