Streaming...................?

Posted by Amin Anwar

What is streaming in Oracle Data base?

This entry was posted on at 5:28 AM. You can follow any responses to this entry through the RSS 2.0. You can leave a response.

  1. gravatar

    # by Amin Anwar - February 8, 2011 at 6:01 AM

    A built-in feature of the Oracle database, is a data replication and integration feature. It provides a flexible infrastructure that meets a wide variety of information sharing needs. Oracle Streams enables the propagation of data, transactions and events in a data stream either within a database, or from one database to another. Click on the following links for further details on Oracle Streams.

  2. gravatar

    # by Amin Anwar - February 8, 2011 at 9:07 PM

    Oracle Streams is the flow of information either within a single database or from one database to another. Oracle Streams can be setup 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

  3. gravatar

    # by Amin Anwar - February 9, 2011 at 5:15 AM

    Oracle Streams allows data propagation between Oracle Databases (homogeneous) and between Oracle and non-Oracle databases (heterogeneous environment).

    Oracle Streams can be used for:

    * Replication
    * Message Queuing
    * Loading data into a Data Warehouse
    * Event Notification
    * Data Protection