# Oracle Streams

> Mediated Wiki article. Canonical URL: https://mediated.wiki/source/Oracle_Streams
> Markdown URL: https://mediated.wiki/source/Oracle_Streams.md
> Source: https://en.wikipedia.org/wiki/Oracle_Streams
> Source revision: 1329264185
> License: Creative Commons Attribution-ShareAlike 4.0 International (https://creativecommons.org/licenses/by-sa/4.0/)

{{refimprove|date=July 2018}}

'''Oracle Streams''' was a product from [Oracle Corporation](/source/Oracle_Corporation) that encouraged users of [Oracle database](/source/Oracle_database)s to propagate information within and between [database](/source/database)s. It provided tools to capture, process ('stage') and manage database events via Advanced Queuing [queues](/source/Queue_(data_structure)).

Oracle Streams was the flow of information either within a single database or from one database to another. Oracle Streams can be set up in homogeneous (all Oracle databases) or heterogeneous (non-Oracle and Oracle databases) environments. The Streams setup used a set of processes and database objects to share data and messages. The database changes ([DDL](/source/Data_Definition_Language) and [DML](/source/Data_Manipulation_Language)) were captured at the source; those are then staged and propagated to one or more destination databases to be applied there. Message propagation used Advanced Queuing mechanism within the Oracle databases.

Applications for the Oracle Streams tool-set included [data distribution](/source/distributed_database), [data warehousing](/source/data_warehouse) and [data replication](/source/data_replication).

This product was later replaced with [Oracle Goldengate](/source/Oracle_Goldengate).

== History ==
As of Oracle version 9.2 (2002), Oracle Corporation made Oracle Streams available on Oracle Enterprise Edition systems only. This happened in the wake of previous replication products: Oracle Replication (introduced with Oracle 8<ref>
{{cite book
| last1                 = Prusinski
| first1                = Ben
| last2                 = Phillips
| first2                = Steve
| last3                 = Chung
| first3                = Richard
| title                 = Expert Oracle GoldenGate
| url                   = https://books.google.com/books?id=DH3vrKvDSOMC
| accessdate            = 2012-08-03
| series                = Apresspod Series
| year                  = 2011
| publisher             = Apress 
| isbn                  = 9781430235668
| page                  = 2
| quote                 = The next step in the march of data replication came into existence with Oracle release 8, which enabled database professionals to set up log-based and trigger-based replication solutions. Oracle Basic Replication [...] existed in two flavors: log-based and trigger-based.
}}
</ref>
in 1997) and Oracle Advanced Replication<ref>
{{cite web
 | url          = http://www.oracle.com/technetwork/database/features/data-integration/oracle-adv-replication-twp-132415.pdf
 | title        = Oracle9i Replication
 | last1        = Pratt
 | first1       = Maria
 |date=June 2001
 | publisher    = Oracle Corporation
 | location     = Redwood Shores, California
 | pages        = 15
 | accessdate   = 2012-08-03
}}
</ref>

Database Replication with Oracle 11G Streams
<ref>
{{cite web
 | url          = https://www.bigdba.com/oracle/47/database-replication-with-oracle-11g-streams/
 | title        = Database Replication with Oracle 11G Streams
 | last1        = COMAK
 | first1       = Bugra
 |date=June 2019
 | publisher    = www.bigdba.com
 | location     = Ankara, Turkey
 | pages        = 1
 | accessdate   = 2019-09-16
}}
</ref>
(introduced with Oracle 9i in 2000).

In July 2009, Oracle acquired [GoldenGate](/source/GoldenGate), a company with a heterogeneous replication solution. {{As of | 2012}} Oracle Corporation encourages customers with new applications to use Oracle GoldenGate rather than Streams.

Oracle Streams was deprecated since Oracle Database version 12c, and desupported since Oracle Database version 19c.<ref>
{{cite web
 | url          = https://support.oracle.com/knowledge/Oracle%20Database%20Products/2388741_1.html
 | title        = Streams Deprecation and Desupport FAQ (Doc ID 2388741.1)
 | date         = Aug 2018
 | publisher    = Oracle Corporation
 | accessdate   = 2023-05-18
}}
</ref>

== Footnotes ==
{{reflist}}

Streams

{{Database-software-stub}}

---
Adapted from the Wikipedia article [Oracle Streams](https://en.wikipedia.org/wiki/Oracle_Streams) by Wikipedia contributors ([contributor history](https://en.wikipedia.org/wiki/Oracle_Streams?action=history)). Available under [Creative Commons Attribution-ShareAlike 4.0 International](https://creativecommons.org/licenses/by-sa/4.0/). Changes may have been made.