EXPERT RESPONSE
If the both the master and the slave databases are Oracle, then the best way to implement replication is to use Oracle's Advanced Replication product. This add-on product is the most efficient method to implement replication between Oracle databases. The product does cost money, but you save in having to implement your own custom replication scheme.
If you have a non-Oracle database in the mix, then replication becomes more complicated. To replicate data from Oracle to another vendor's database, you can create a database link to the non-Oracle database using Oracle's Hetergenous Services. You can then create triggers on the tables to be replicated and write your own routines to replicate the data through the database link.
For replicating from a non-Oracle database to Oracle, the solution becomes even more complicated. You can see if your non-Oracle database implements something similar to Oracle's Hetergenous Services and then create a trigger to replicate the data. If this solution is not feasible, then you will have to code triggers to call external programs which will perform the replication for you. These external programs can be Java and use JDBC to connect to the Oracle database, or they can be any programming platform that supports ODBC connectivity.
|
