You can change a horizontally partitioned or vertically partitioned replication configuration while replication is active. Both of these procedures require the reactivation of the active replication configuration, but SharePlex only locks tables that are associated with those changes.
Oracle
All targets
To change horizontally partitioned replication
Issue one of the following commands to change the partition or partition scheme. For syntax and other information, see the alphabetical command listings in the SharePlex Reference Guide.
Command | Auth. level | Description |
---|---|---|
add partition |
2 | Creates partition schemes and row partitions. |
drop partition |
2 | Removes a row partition from a partition scheme. |
drop partition scheme |
2 | Removes a partition scheme. |
modify partition |
2 | Modifies a row partition of a partition scheme. |
If you dropped a partition scheme:
Copy (but do not deactivate) the active configuration file to a new file.
sp_ctrl> copy config filename to newname
Edit the copy to remove or change the routing map where the partition scheme was specified.
sp_ctrl> edit config filename
Activate the new configuration file.
sp_ctrl> activate config filename
To change vertically partitioned replication
Make a copy of (but do not deactivate) the active configuration file.
sp_ctrl> copy config filename to newname
Edit the copy to change the appropriate column partition.
sp_ctrl> edit config filename
Activate the new configuration file.
sp_ctrl> activate config filename
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center