Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
Is it possible to have more than one partition scheme associated with a table in Horizontal Partitioned replication
설명
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]
원인
More than one partition scheme is associated with a particular table.
해결 방안
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.
