The “copy force” command errors out with “Unknown parameter” when trying to sync a replicating (4299815)

The following errors are observed in sp_ctrl when using copy with “force” option to sync a replicating table

sp_ctrl (irvsupu16:5438)> copy force owner.source_table to owner.target_table

   Unknown parameter: 'owner.source_table'

   Usage: copy {source_owner}.{source_table}

               [to {target_owner}.{target_table}[.{partition}]]

               [at {target_host}[@o.{target_sid}]]

               [for o.{source_sid}]

               [force]

               [on {host}] | [on {host}:{port}] |

                    [on {login}/{password}@{host}] |

                    [on {login}/{password}@{host}:{port}]

The “force” option is only meant to be used with tables not in replication.

“copy force” may not be used to copy a replicating table. The “force” option is only meant to be used with a non-replicating table. The correct way to sync a replicating table using copy is to use one of the following syntaxes:

copy {source_owner}.{source_table}

               [to {target_owner}.{target_table}[.{partition}]]

               [at {target_host}[@o.{target_sid}]]

               [for o.{source_sid}]

               [on {host}] | [on {host}:{port}] |

                    [on {login}/{password}@{host}] |

                    [on {login}/{password}@{host}:{port}]