Versions Compared

Key

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

...

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

...

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.* Note: If a whole schema is replicated, then new tables in the source database will automatically be created in the target database (Oracle target databases only). 

Loading data before table is added to replication

...