O'Reilly logo

Oracle 11g Streams Implementer's Guide by Eric Yen, Ann L. R. McKinnell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4. Single-Source Configuration

The stream flows one way: Downhill

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required