Return
-
Title
Is it possible to have more than one partition scheme associated with a table in Horizontal Partitioned replication -
Description
Activation fails for a table as below:Warning 2015-01-14 16:00:17.756000 5100 3392 Activation: Skipping duplicate entry for "OWNER"."TABLE_NAME" in line nn - Source is defined in line nn with a horizontal partitioning scheme and a horizontally partitioned table may be defined only once. (activating sid MAXQA) [module ocf] -
Cause
More than one partition scheme is associated with a particular table. -
Resolution
You cannot have more than one partition scheme associated with a particular table. This is the reason the activation fails. You can use the same partition scheme and still have multiple entries, one for each column condition.