Oracle Advanced Replication Setup

Oracle Advanced Replication is a mechanism to replicate data from one database to another using materialized views. These views are updatable and hence changes in one database are replicated to another database and also vice versa.

Using Advanced Replication, we can keep a specific copy of a table as a materialized view in another database. You have a total control of specifying the refresh timings e.g. you can setup advanced replication to refresh say every 15 minutes or once a day etc. As you can now imagine, using this you can keep a backup copy of tables somewhere else and also going a step forward, you can offload some of your traffic on to the other synchronized database.

This note discusses step by step way to setup Oracle Advanced Replication using updatable materialized views.

It is a cache 22 situation, if you do not get an opportunity to play around with Oracle Advanced Replication, then you are not going to learn it hands on and you must have some hands on experience in order to gain a job which has oracle advanced replication implemented.

You can now come out of these shackles and learn Oracle Advanced Replication at your home! Our personal notes teach you exactly that i.e. it is a step by step instructions using free technologies to set up Oracle Advanced Replication using updatable materialized views. Note that we use these notes only to setup Oracle Adv Replication in our test environments, so it really works! Once you have followed and setup Oracle replication, you can try all your commands you have been waiting for.

Go to the next page and you can see our entire catalogue of Database Study material list