The "copy table" or "append table" results in "cannot copy <tablename>" and "Source name i (49167)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

The "copy table" or "append table" results in "cannot copy <tablename>" and "Source name i
Description

copy tablecommand fails as follows:
sp_ctrl (server_name:port_num)> copy source_table to target_table
Cannot copy SOURCE_TABLE
Source name is invalid
Or
sp_ctrl (server_name:port_num)> copy owner.source_table to target_table
Cannot copy OWNER.SOURCE_TABLE
Destination name is invalid
Cause

Incomplete syntax has resulted in the above errors.
Resolution

Fully qualified source and/or target table names must be supplied, namely owner.tablename and not just tablename. So, the correct command to issue would be:
sp_ctrl (server_name:port_num)> copy owner.source_table to owner. target_table

The error also shows up when querying the status with the intent of issuing copy status but ending up typing something else as below due to typo:
sp_ctrl (server_name:port_num)> copy satus
Cannot copy SATUS
Source name is invalid
The correct command to issue in this case is
sp_ctrl (server_name:port_num)> copy status

Feedback Submitted

Did this article solve an issue for you?

Select Rating

The "copy table" or "append table" results in "cannot copy &lt;tablename&gt;" and "Source name i (49167)