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
Incomplete syntax has resulted in the above errors.
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
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy