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 (12.1.0.1), 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.
Enjoy!
Reference:
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
Current Oracle Certs

Bobby Curtis
I’m Bobby Curtis and I’m just your normal average guy who has been working in the technology field for awhile (started when I was 18 with the US Army). The goal of this blog has changed a bit over the years. Initially, it was a general blog where I wrote thoughts down. Then it changed to focus on the Oracle Database, Oracle Enterprise Manager, and eventually Oracle GoldenGate.
If you want to follow me on a more timely manner, I can be followed on twitter at @dbasolved or on LinkedIn under “Bobby Curtis MBA”.


But, then, one has to purchase the Golden Gate licence. Advanced Replication (which I really like) is free with EE.
Hemant K Chitale
You miss one point: GG costs a lot of money, Streams nothing!
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.
What do you make of this documentation for 12c describing Advanced replication?
https://docs.oracle.com/database/121/REPLN/repoverview.htm#REPLN001
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.