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

The setup

Here is the big picture for this chapter. We will create a new user and tablespace to isolate all the examples used in this chapter. That user's schema will contain one table replicated between STRM1 and STRM2 database. Both STRM1 and STRM2 are sources. STRM1 is the source for STRM2 and vice-versa. The Streams Administrator will configure the Streams environment. Conflict resolution will handle the situation where the exact same data inputted on one or more sources at the same time. The conflict resolution will use the built-in MAXIMUM confliction resolution handler.

The set-up table is given as follows:

Description

Value

New User

LEARNING

Table

EMPLOYEE

New Tablespace

LEARNING

Replication Type

N-Way

Conflict Resolution

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