Oracle Streams

In <a href="/facts/Computing/Kghtm9fX">computing</a>, the Oracle Streams was a product from <a href="/facts/Oracle_Corporation/0z14FygH">Oracle Corporation</a> that encouraged users of <a href="/facts/Oracle_database/FHv5g732">Oracle databases</a> to propagate information within and between <a href="/facts/Database/VYcpkevb">databases</a>. It provided tools to capture, process ('stage') and manage database events via <a href="/facts/Oracle_Advanced_Queuing/dm6t8v1v">Advanced Queuing</a> <a href="/facts/Queue_(data_structure)/hVPjPXus">queues</a>.
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 (<a href="/facts/Data_Definition_Language/Hx7aNozV">DDL</a> and <a href="/facts/Data_Manipulation_Language/eeJRDUEl">DML</a>) 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 <a href="/facts/Distributed_database/A6Q1s4Iy">data distribution</a>, <a href="/facts/Data_warehouse/we5rblq9">data warehousing</a> and <a href="/facts/Data_replication/QIaooMjL">data replication</a>.
This product was later replaced with Oracle Goldengate.

Oracle Streams open-in-new

Oracle Streams