Then you can't use COPY command. only possible way is

Create table table_name as select * from table_name1@dblink where ....