Return
-
Title
Running compare gives error Unknown parameter: 'target' -
Description
When compare is run, the following errors are observed:
sp_ctrl (alvsupu07:5439)> compare owner.source_table to owner.target_table target targetservername@O.targetSID
Unknown parameter: 'target'
Usage: compare {source_owner}.{source_table}[.{partition}]
[not ({list of exceptions})]
[to {target_owner}.{target_table}[.{partition}]]
[at {target_host}[@o.{target_sid}]]
.
.
-
Cause
There is a syntax error in the command issued as above.
-
Resolution
The keyword "table" is missing in the command. The command needs to be re-issued as below:
sp_ctrl (alvsupu07:5439)> compare table owner.source_table to owner.target_table target targetservername@O.targetSID
Starting with Shareplex 7.6, the new syntax for compare is:
sp_ctrl (alvsupu07:5439)> compare owner.source_table to owner.target_table targetservername@O.targetSID
Note that the keyword “target” has been deprecated in the new syntax. However, the command still takes the old syntax which has additional keywords "table" and "target" as below:
sp_ctrl (alvsupu07:5439)> compare table owner.source_table to owner.target_table target targetservername@O.targetSID -
Additional Information
Please refer to Shareplex Reference Guide for details on the compare command.