Chat now with support
Chat with Support

SharePlex 9.2.7 - Installation and Setup for Oracle Source

About this Guide Conventions used in this guide SharePlex pre-installation checklist Download the SharePlex installer Installation and setup for Oracle cluster Installation and setup for remote capture Install SharePlex on Linux and UNIX Install SharePlex on Windows Assign SharePlex users to security groups Set up an Oracle environment for replication Set up replication from Oracle to a different target type Generic SharePlex demonstration-all platforms Advanced SharePlex demonstrations for Oracle Solve Installation Problems Database Setup Utilities General SharePlex Utilities Uninstall SharePlex Advanced installer options Install SharePlex as root Run the installer in unattended mode SharePlex installed items

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

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

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating