-
Title
Running compare in a Horizontal or Vertical Partitioned replication environment. -
Description
What is the syntax for running compare in a Horizontal and/or Vertical Partitioned replication environment?
-
Resolution
NOTE: This solution refers to SharePlex Partitions and NOT Oracle Partitions.
When compare is issued for tables that are configured for Partitioned replication, the compare table command determines the rows and columns to compare by reading the configuration file and, for Horizontally Partitioned replication, the column conditions stored internally in SharePlex.
For Vertically Partitioned tables where Source and Target column names are different, the compare table command maps the Source columns to the Target columns and constructs the correct WHERE clause for each table.
For Horizontally Partitioned replication, the compare table command reads the column conditions for the Source table and selects rows for the Source and Target tables based on those conditions.
Therefore the compare syntax for a table that is Vertically and/or Horizontally Partitioned is the same as for a regular table.
compare table owner.source_table to owner.target_table target target_host @o.target_SID
NOTE:
When running compare in a Horizontal or Vertical Partitioned replication environment, SharePlex is only able to compare/repair the rows/columns that form part of replication.
If an attempt is made to compare rows/columns that are not part of replication (by using where clause), SharePlex may simply declare them as In Sync.