When you say copy.. do you mean....

create table as select ... from using database link

please let me know..