Procedure to change the characteristic of an already replicating TARGET table from non-partitione (4330856)

At times one may need to make structural change to TARGET table by changing it from non-partitioned to partitioned or vice versa. The procedure for doing so is very simple.

N.A.

The procedure involved is:

1. Stop Post.
2. Create the new table as partitioned or non-partitioned depending on what you are trying to do and  insert the data from the existing replicated table to the new table.
3. Drop or rename the original table to some other name.
4. Rename the new table to the original name (as listed in the config file entry for the target table name).
5. Make sure that the structure of the new table in terms of index, constraint, etc is similar to the old one.
6. Start Post.

On target side Shareplex does not care about the object id of the replicating table but only posts by the object name. So even if our new target table has a new object id, it will not affect replication since the name still remains same.

NOTE: This solution applies to changing the partition characteristic of TARGET table only.  If changing the partition characteristic of the SOURCE table, please refer to Shareplex Admin Guide Chapter 9 titled "Changing Oracle Characteristics of Replicated Objects" Part 1 as the procedure is very different and requires reactivation.