Advanced Replication and Streams are dead! – 12 edition

As more and more people start to take a closer look at Oracle Database 12c, I believe more will start to see the usefulness in many of the new features.  However, at the same time many of the older features that everyone has come to love will be discontinued.  Two such features are the Advanced Replication and Oracle Streams options within Oracle.  As of Oracle Database 12c (, Oracle is making a fundamental switch to newer technology within their stack of products.  As of the release of 12c, Advanced Replication and Oracle Streams are being discontinued. Moving forward, Oracle Golden Gate is going to replace all features of Advanced Replication and Oracle Streams!

These features include (listed in documentation):

            1. Multi-master replication

            2. Updateable Materalized Views

            3. Hierarchical Materialized Views

            4. Deployment Templates.

I for one am looking forward to this change.  When I first read this in the beta documentation (confirmed in GA docs) and starting looking through the data dictionary views, I got really excited.  Oracle has decided to switch to a very useful tool that was mostly used for migration purposes.  In my opinion, a change like this is showing that Oracle has committed to the Golden Gate product and has confidence in it moving forward.

In Oracle’s commitment to Golden Gate, many of you will notice that Oracle has created views to help monitor the Golden Gate process within the Oracle Database 12c.  I noticed this during beta testing (being a Golden Gate guy) started to look for docs on how it was going to work.  At this point, I haven’t found any docs on the integration between Oracle Database 12c and Golden Gate in the database docs.  

This is something that I’m defiantly excited about trying out and see how this is going to work.  As I find out more, I’ll be posting it here.


Oracle Database Upgrade Guide 12c Release 1 (12.1) (E17642-13)
8.1.6 Deprecation of Oracle Streams
8.1.7 Deprecation of Advanced Replication

Please follow and like:
    • You are correct – GG costs, that cost is based on what you are trying to do with the technology. You will notice that in DB12c, Streams and Advanced Replication are still in the documentation. This is because Oracle is still supporting those technologies until some predetermined date. GG is the direction Oracle is going, but it appears to be phased in over time.
      In talking with Oracle, a new release of GG is due to follow DB12c. When it comes out, I don’t know. I’m waiting for this as well, since the views in DB12c are going to be used with GG. The question is how.
      In the end, GG is the direction which Oracle appears to be going and how it will be licensed in the future, we’ll have to wait and see.

    • Advance replication is still in the 12.1 database. The documentation which I reference states that it is depreciated moving forward. Will in be in 12.2 or later release of the database? May have to invest in time/money for Oracle Cloud to see since 12.2 is only available on the cloud platform currently.

Comments are closed.

Enquire now

Give us a call or fill in the form below and we will contact you. We endeavor to answer all inquiries within 24 hours on business days.