You can use SELECT/INSERT or other types of Heterogeneous Replication with Oracle Transparent Gateway and Generic Connectivity.

See Oracle manual for Heterogeneous Connectivity.

Regards.