The following errors are observed when adding a second partition scheme for a table involved in Horizontal Partitioning and activating again:
Warning 2015-01-14 16:00:17.756000 5100 3392 Activation: Skipping duplicate entry for "OWNER"."SOURCETABLE" in line 57 - Source is defined in line 56 with a horizontal partitioning scheme and a horizontally partitioned table may be defined only once. (activating sid sourceSID) [module ocf]
The partition scheme fails to take effect though the earlier Horizontal Partitioning associated with the table are still valid.
A table can only have one partition scheme associated with it.
If needed, add the new column condition (that was used in the newly added partition scheme) in the existing partition scheme at a later time. For details on changing the partition scheme of a table in replication, refer to Shareplex Administrator Guide.