Adding new tables
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 |
---|
| Panel |
---|
| dbvrep> PREPARE TABLE schema.table_name |
|
|
Ensure that the appropriate privileges are given to the Dbvisit Replicate owner on both the source and target. The privileges are:
Section |
---|
Column |
---|
| Panel |
---|
| SQL> grant select, update, insert, delete to dbvrep; |
|
|
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
Loading data before table is added to replication
Adding new schemas
...