Oracle Streams

From Wikipedia, the free encyclopedia
Jump to: navigation, search

In computing, the Oracle Streams product from Oracle Corporation encourages users of Oracle databases to propagate information within and between databases. It provides tools to capture, process ('stage') and manage database events via Advanced Queuing queues.

Oracle Streams is 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 uses a set of processes and database objects to share data and messages. The database changes (DDL and DML) are captured at the source; those are then staged and propagated to one or more destination databases to be applied there. Message propagation uses Advanced Queuing mechanism within the Oracle databases.

Applications for the Oracle Streams tool-set include data distribution, data warehousing and data replication.


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[1] in 1997) and Oracle Advanced Replication[2] (introduced with Oracle 9i in 2000).

In July 2009, Oracle acquired 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.


  1. ^ Prusinski, Ben; Phillips, Steve; Chung, Richard (2011). Expert Oracle GoldenGate. Apresspod Series. Apress. p. 2. ISBN 9781430235668. Retrieved 2012-08-03. 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. 
  2. ^ Pratt, Maria (June 2001). "Oracle9i Replication" (PDF). Redwood Shores, California: Oracle Corporation. p. 15. Retrieved 2012-08-03.