-
Title
Difference between Oracle Partitioning and Shareplex Partitioning -
Description
Difference between Oracle Partitioning and Shareplex Partitioning.
-
Cause
General information. -
Resolution
Oracle partitioning is used to efficiently manage a large table by subdividing it and its indexes into smaller portions on the basis of a partition key. As far as replication is concerned, Oracle partitioning can be applied on both source and target objects.
Shareplex Partitioning is a term used to replicate a subset of columns of a table ( Vertical Partitioning) and/or subset of rows (Horizontal Partitioning). The exclusion criteria in case of Vertical Partitioning is derived from the config file entry which specifies which column are to be replicated whereas for Horizontal Partitioning it is derived from the COL_CONDITIONS (representing column condition) field in Shareplex internal table.
The Oracle Partitioning affects every row of a table, whether on source or target, depending on where Oracle partitioning exists.
SHAREPLEX_PARTITION. The Shareplex partitioning only affects target table in the sense that the exclusion criteria decides which row and/or columns will be replicated to the target.