Working on creating a muti-master replication for a production system. Each database needs to be active and replicate changes back to the other so data availability along with distributed transactions is guaranteed. The only challenge is to do this without purchasing a 3rd party product. Materialized views is looking the easiest and best option right now.
Writeable Materialized View would be easy to implement. After evaluating a couple of 3rd part products and avoiding the licensing cost of GoldenGate I have decided to bravely move forward with MV. I will update the blog soon with how I went about implementing it. The only saving grace for MV would be that the schema which needs to be put across the remote database is less complex. It has only 9 tables and 1 PL/SQL procedure.
