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}]
