-
Book Overview & Buying
-
Table Of Contents
Oracle 11g Streams Implementer's Guide
In this chapter, we will look at configuring single-source streams replication using Enterprise Manager (EM) DB Console (this can also be applied if you are using Enterprise Manager Grid Control). We will also provide the PL/SQL API calls being issued behind the scenes. The PL/SQL for these calls can be copied to a script and used to configure Streams from the command line as well. This chapter is organized as follows:
The Enterprise Manager: This takes you step-by-step through the EM Streams setup wizard, using a schema-level replication example
The code behind the curtain: A step-by-step walk-through the PL/SQL code that configures the Stream
Sequences, and triggers, and apply: Points out expected behavior of sequence and triggers in our example, as well as special case considerations
Other levels at which to replicate: Provides a brief description of other replication levels that can be used and the beauty of the...
Change the font size
Change margin width
Change background colour