SharePlex 9.2.6 - Installation and Setup for Oracle Source

Change Partitioned Replication

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.

Supported databases

Oracle or SQL Server source

All targets

To change horizontally partitioned replication

1. Run sp_ctrl.

2. 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.

3. If you dropped a partition scheme:

   1. Copy (but do not deactivate) the active configuration file to a new file.

      sp_ctrl> copy config filename to newname

   2. Edit the copy to remove or change the routing map where the partition scheme was specified.

      sp_ctrl> edit config filename

4. Activate the new configuration file.

   sp_ctrl> activate config filename

To change vertically partitioned replication

1. Make a copy of (but do not deactivate) the active configuration file.

   sp_ctrl> copy config filename to newname

2. Edit the copy to change the appropriate column partition.

   sp_ctrl> edit config filename

3. Activate the new configuration file.

   sp_ctrl> activate config filename