-
Title
The "copy table" fails with "Unknown parameter: 'value' " -
Description
A. The copy table fails as follows:
sp_ctrl (server_name:port_num)> copy table owner.source_table to owner.target_table
Unknown parameter: 'owner.source_table'
Usage: copy {SOURCE_OWNER.EN}.{SOURCE_TABLE.EN}[to {TARGET_OWNER.EN}.{TARGET_TABLE.EN}[.{PARTITION.EN}]]..Or
B. The copy table fails as follows:
sp_ctrl (server_name:port_num)> copy owner.source_table owner.target_tableUnknown parameter: 'owner.target_table'
Usage: copy {SOURCE_OWNER.EN}.{SOURCE_TABLE.EN}[to {TARGET_OWNER.EN}.{TARGET_TABLE.EN}[.{PARTITION.EN}]].. -
Cause
Use of keywords not available in the command or the omission of keywords have caused the error.
-
Resolution
The following is the description of the issue encountered and the resolution thereof:
A. There is no keyword named "table" in syntax of the copy command, something that was mistakenly supplied in this example. If the command is again issued as follows with the word "table" omitted, it will succeed:
copy owner.source_table to owner.target_table
B. The keyword "to" was omitted, resulting in the above error. If the command is issued again the keyword "to" included, it will succeed:
copy owner.source_table to owner.target_table