How to Split Partition or Add New Partition (4214716)

What is the procedure to split a partition or add a new partition for a table in replication, so that replication does not break?

Splitting the Oracle partition or adding a new partition to a replicating table requires a reactivation before users access the partition, so that SharePlex can incorporate the new partition information before data changes are made.

Take the following steps:

1. Add the Oracle partition to the source and target tables.

2. Run sp_ctrl.

3. Reactivate the configuration using default activation.

sp_ctrl(sysA)> activate config filename

4. Wait until activation is complete before allowing users to access the new partition.