Page Comparison

...

dbvrep> PREPARE TABLE schema.table_name

The table needs to exist on both the source and target before this command can be given. If the table was created recently, make sure that mine has already parsed the logs beyond the time of the table creation, so it learned that the table exists. Ensure that the appropriate privileges are given to the Dbvisit Replicate owner on both the source and target. The privileges are:

...

1. Pause the apply process (PAUSE APPLY)
2. PREPARE the new table. Dbvisit Replicate will give the SCN of where the table will be replicated from.
3. Use the SCN from step 2 to load the historical data (Example use datapump with flashback_scn=xxx)
4. Resume the replication (RESUME APPLY)

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

Adding new schemas

...

To add a new schema to the replication run the following command.

Panel
bgColor CCC
dbvrep> PREPARE SCHEMA schema

All the tables within the schema must be initialized in the same way as described above for the single table preparation. Follow those steps to ensure there is no data missing on the target side.

Removing tables & schemas

...