Skip Headers
Oracle® Streams Extended Examples
11
g
Release 2 (11.2)
Part Number E12862-03
Home
Book List
Index
Master Index
Contact Us
Next
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
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
Scripting on this page enhances content navigation, but does not change the content in any way.