Oracle-to-Oracle data integration is treated separately as Oracle offers products that have been optimized for moving data between Oracle database instances. These products can only be used when both the source and target databases are Oracle databases. Oracle has had a long history of Oracle-to-Oracle-based solutions, including Oracle Replication Server and Oracle imp/exp. These key legacy Oracle-to-Oracle integration solutions have been replaced by Oracle Streams and Oracle Data Pump, respectively.
Oracle Streams is a log-based solution that enables the propagation and management of data, transactions, and events in a data stream either within an Oracle database, or from one Oracle database to another. The stream routes published information to subscribed destinations. Streams supports capture and apply from Oracle to non-Oracle systems. However, the apply or capture from non-Oracle systems must be custom-coded, or through an Oracle Transparent or Generic...