We currently have a replication at schema level and want to add another schema to the replication.This article explains the best way to achieve this .
This can be done using the
PREPARE SCHEMA command.
From the Dbvisit Replicate console:
- Pause the APPLY process:
dbvrep> PAUSE APPLY
- Prepare the schema:
dbvrep> PREPARE AS OF <<YOUR\_SCN\_NUMBER\_HERE>> SCHEMA <<SCHEMA\_NAME>>
- Instantiate Data by loading data from the source into the target. This can be done using the Oracle Datapump tool.
- Once import is complete, resume the APPLY process:
dbvrep> RESUME APPLY
For more details, please see:
Ankit Arora November 03, 2014 15:06