...
- Pause the replication (PAUSE MINE)
- PREPARE the new table. Dbvisit Replicate will give the SCN of where the table will be replicated from.
- Use the SCN from step 2 to load the historical data (Example use datapump with flashback_scn=xxx)
- Resume the replication (RESUME MINE)
Adding new
...
schemas
Removing tables & schemas
...