1/11

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Changes in This Release for Oracle Streams Extended Examples

• Changes in Oracle Database 12c Release 1 (12.1)

1 Simple Single-Source Replication Example

• Overview of the Simple Single-Source Replication Example
• Prerequisites
• Create Queues and Database Links
• Configure Capture, Propagation, and Apply for Changes to One Table
• Make Changes to the hr.jobs Table and View Results

2 Single-Source Heterogeneous Replication Example

• Overview of the Single-Source Heterogeneous Replication Example
• Prerequisites
• Create Queues and Database Links
• Example Scripts for Sharing Data from One Database
  • Simple Configuration for Sharing Data from a Single Database
  • Flexible Configuration for Sharing Data from a Single Database
• Make DML and DDL Changes to Tables in the hr Schema
• Add Objects to an Existing Oracle Streams Replication Environment
• Make a DML Change to the hr.employees Table
• Add a Database to an Existing Oracle Streams Replication Environment
• Make a DML Change to the hr.departments Table

3 N-Way Replication Example

• Overview of the N-Way Replication Example
• Prerequisites
• Create the hrmult Schema at the mult1.example.com Database
• Create Queues and Database Links
• Example Script for Configuring N-Way Replication
• Make DML and DDL Changes to Tables in the hrmult Schema

4 Single-Database Capture and Apply Example

• Overview of the Single-Database Capture and Apply Example
• Prerequisites
• Set Up the Environment
• Configure Capture and Apply
• Make DML Changes, Query for Results, and Dequeue Messages

5 Logical Change Records with LOBs Example

• Example Script for Constructing and Enqueuing LCRs Containing LOBs

6 Rule-Based Application Example

• Overview of the Rule-Based Application
• Using Rules on Nontable Data Stored in Explicit Variables
• Using Rules on Data in Explicit Variables with Iterative Results
• Using Partial Evaluation of Rules on Data in Explicit Variables
• Using Rules on Data Stored in a Table
• Using Rules on Both Explicit Variables and Table Data
• Using Rules on Implicit Variables and Table Data
• Using Event Contexts and Implicit Variables with Rules
• Dispatching Problems and Checking Results for the Table Examples

Index