Return
-
Title
Horizontal partition Table replicates all data -
Description
When you have a horizontally partitioned table in the configuration, you notice that it replicates all the table data over to the target.
-
Cause
Partition_scheme is not included in the active configuration
-
Resolution
1. Make sure that there is a proper entry in Shareplex_partition table
2. Make sure partition_schema is in the existing configuration file. If not, add it to the end of route.
Example:
owner.test owner.test !sales_partition
! target_host@o.target_SID