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)
  • Deprecated Features

1 Simple Single-Source Replication Example

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

2 Single-Source Heterogeneous Replication Example

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

3 N-Way Replication Example

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

4 Single-Database Capture and Apply Example

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

5 Logical Change Records with LOBs Example

• 5.1 Example Script for Constructing and Enqueuing LCRs Containing LOBs

6 Rule-Based Application Example

• 6.1 Overview of the Rule-Based Application
• 6.2 Using Rules on Nontable Data Stored in Explicit Variables
• 6.3 Using Rules on Data in Explicit Variables with Iterative Results
• 6.4 Using Partial Evaluation of Rules on Data in Explicit Variables
• 6.5 Using Rules on Data Stored in a Table
• 6.6 Using Rules on Both Explicit Variables and Table Data
• 6.7 Using Rules on Implicit Variables and Table Data
• 6.8 Using Event Contexts and Implicit Variables with Rules
• 6.9 Dispatching Problems and Checking Results for the Table Examples

Index