We're here to help!

Syncing one table with the Prepare and Load command

Follow
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:

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>
Have more questions? Submit a request

Comments