Versions Compared

Key

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

Adding new tables

...

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.

One-to-Many Replication

In one-to-many replication, you have to choose replicaiton process before preparing table for replication.

Section
Column
width5%

 

Column
width95%
Panel
bgColorCCC
dbvrep> CHOOSE REPLICATION APPLY
dbvrep> PREPARE TABLE schema.table_name
 
dbvrep> CHOOSE REPLICATION APPLY1
dbvrep> PREPARE TABLE schema.table_name

Loading data before table is added to replication

...

Info

The PREPARE commands add supplemental logging to the table if it was not there yet. This can unfortunately result in the ORA-01466 error while performing step 3.

Therefore, use following commands to prepare a new table. In following example, scott.emp table is prepared. It first adds the supplemental logging, then waits for the SCN to advance then it does the actual PREPARE: 

dbvrep>ENGINE SUPPLEMENTAL LOGGING TABLE SCOTT.EMP ENABLE PRIMARY KEY
dbvrep>ENGINE WAIT_SCN_FLIP
dbvrep>PREPARE TABLE SCOTT.EMP

Note that the table needs to exist on the target side before the apply process can be resumed. Using datapump in step 3 is a good choice, since the import creates the table automatically if it does not exist.

...