Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Adding new tables

Once the replication has been configured and is running, new objects can be added to the replication. 
New tables can be replicated with the command:

 

Section
Column
width5%

 

Column
width95%
Panel
bgColorCCC
dbvrep> PREPARE TABLE schema.table_name

Ensure that the appropriate privileges are given to the Dbvisit Replicate owner on both the source and target. The privileges are:

Section
Column
width5%

 

Column
width95%
Panel
bgColorCCC
SQL> grant select, update, insert, delete to dbvrep;

If a DDL replication was enabled during the Setup Wizard (Step 2 - Replication pairs), the Dbvisit Replicate owner 
on the target database already has SELECT/INSERT/UPDATE/DELETE ANY privileges. No other grants should be necessary

Loading data before table is added to replication

Adding new schemas

...