Copy table data between Oracle databases on the fly without creating a database link

copy from user/pass@source to user/pass@dest create table_name using select * from table_name

this sqlplus command create a table in destination database and insert all tables data from source database

more infos