Copy data between databases

In oracle, you can copy data between linked databases via normal SQL.

insert into table select * from table@db_link

The databases can even be on different physical machines.