This article explains how to add a new table to replication and also load the table with the Dbvisit Replicate LOAD utility.
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:
dbvrep> PREPARE_AND_LOAD TABLE SCOTT.REPTEST3 Prepare enabled supplemental logging, waiting for SCN advance enough to prevent ORA-01466 during consistent export....Waited 0 seconds until scn_to_timestamp changed. Connecting to running apply [SCOTT.REPTEST3]: [Apply table removed (0 metadata record(s)). Apply table added (1 metadata record(s)).] Connecting to running mine [SCOTT.REPTEST3]: [Table prepared (1 internal records).] Table SCOTT.REPTEST3 instantiated at SCN 29867278 Table SCOTT.REPTEST3 will be loaded using SCN 29867278. Connecting to running mine [SCOTT.REPTEST3]: [1 records processed.]
Resume the MINE process:
dbvrep> resume MINE dbvrep>