Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Propagation

In Oracle Streams, the changes, or messages, are pushed from the source queue to the destination queue. Streams clients do not pull these messages. When the messages are staged in the source queue, a process called the propagation process sends, or pushes, these changes to the destination queue. For a given source queue, there could be multiple destination queues, and for a single destination queue, there could be multiple source queues. A single queue can be a destination queue for one or more propagations and a source queue for other propagations.

Rules can be defined for the propagation process to propagate or discard messages. The rules can be in a positive rule set or a negative rule set. If the propagation process must propagate all messages from the source queue to the destination queue, you do not need any rule set attached to the propagation. Rules can be defined at the global (database) level, schema level, or table level. At the table level, subset rules can be defined that satisfy a certain DML condition to replicate only a portion of a given table.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint