Sync two Oracle production server databases
You could use database link to transfer data between servers.

Assuming you already have the link set up, replicating data can be as simple as:

insert into target_table
select * from source_table@link_name;
commit;


Of course this will be more involved if the data volume is large or you have complex schema.