Distributed Transactions Oracle 11g

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.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s