Using "copy table" or "append table" command in a HA environment (4282678)

Starting with Shareplex 6.0 and up, the "copy table" has been introduced to sync tables. It uses Oracle's Export/Import utility and has a number of options available which includes synchronizing tables not involved in replication. This solution delves on the limitations of the copy command when synchronizing object(s) in a High Availability (HA) environment. The solution also applies to the  "append table" command.

The "copy table" command may not always be suitable in a HA environment. The series of steps occurring during sync may result in the Capture in secondary side gathering the DMLs that were executed to sync the table on HA side by the Oracle Import process. This may warrant additional steps after the copy to maintain the integrity of the data.