Introduction to Data Replication and Integration
“Introduction to Data Replication and Integration”
About Data Replication and Integration
“About Data Replication and Integration”
About Data Replication and Integration Features
“About Data Replication and Integration Features”
When to Access and Modify Information in Multiple Databases
“When to Access and Modify Information in Multiple Databases”
When to Replicate Data with Oracle Streams
“When to Replicate Data with Oracle Streams”
When to Replicate Data with Materialized Views
“When to Replicate Data with Materialized Views”
When to Send Messages Between Databases
“When to Send Messages Between Databases”
Common Data Replication and Integration Tasks
“Common Data Replication and Integration Tasks”
Setting the GLOBAL_NAMES Initialization Parameter to TRUE
“Setting the GLOBAL_NAMES Initialization Parameter to TRUE”
Tutorial: Configuring an Oracle Streams Administrator
“Tutorial: Configuring an Oracle Streams Administrator”
Tutorial: Creating the Tablespace for the Oracle Streams Administrator
“Tutorial: Creating the Tablespace for the Oracle Streams Administrator”
Tutorial: Creating an Oracle Streams Administrator
“Tutorial: Creating an Oracle Streams Administrator”
Creating an ANYDATA Queue
“Creating an ANYDATA Queue”
Tutorial: Creating a Database Link
“Tutorial: Creating a Database Link”
Accessing and Modifying Information in Multiple Databases
“Accessing and Modifying Information in Multiple Databases”
About Accessing and Modifying Information in Multiple Databases
“About Accessing and Modifying Information in Multiple Databases”
About Distributed SQL
“About Distributed SQL”
About Synonyms and Location Transparency
“About Synonyms and Location Transparency”
About Accessing and Modifying Information in Non-Oracle Databases
“About Accessing and Modifying Information in Non-Oracle Databases”
About Stored Procedures
“About Stored Procedures”
Preparing to Access and Modify Information in Multiple Oracle Databases
“Preparing to Access and Modify Information in Multiple Oracle Databases”
Tutorial: Querying Multiple Oracle Databases
“Tutorial: Querying Multiple Oracle Databases”
Tutorial: Modifying Data in Multiple Oracle Databases
“Tutorial: Modifying Data in Multiple Oracle Databases”
Tutorial: Running a Stored Procedure in a Remote Oracle Database
“Tutorial: Running a Stored Procedure in a Remote Oracle Database”
Working with Data in Non-Oracle Databases
“Working with Data in Non-Oracle Databases”
Configuring Oracle Databases to Work with Non-Oracle Databases
“Configuring Oracle Databases to Work with Non-Oracle Databases”
Best Practices for Working with Non-Oracle Databases
“Best Practices for Working with Non-Oracle Databases”
Reduce Post Processing
“Reduce Post Processing”
Tune the Non-Oracle Database
“Tune the Non-Oracle Database”
Set the Relevant Initialization Parameters
“Set the Relevant Initialization Parameters”
Check the Location of the Oracle Database Gateway Installation
“Check the Location of the Oracle Database Gateway Installation”
Ensure Adequate Memory
“Ensure Adequate Memory”
Consider Case Differences
“Consider Case Differences”
Replicating Data Using Oracle Streams
“Replicating Data Using Oracle Streams”
About Oracle Streams Replication
“About Oracle Streams Replication”
Oracle Streams Information Flow
“Oracle Streams Information Flow”
About Change Capture
“About Change Capture”
About Change Capture with a Capture Process
“About Change Capture with a Capture Process”
Capture Process
“Capture Process”
About Change Capture with a Synchronous Capture
“About Change Capture with a Synchronous Capture”
Synchronous Capture
“Synchronous Capture”
About Change Propagation Between Databases
“About Change Propagation Between Databases”
Propagation
“Propagation”
About Change Apply
“About Change Apply”
Apply Process
“Apply Process”
About Rules for Controlling the Behavior of Capture, Propagation, and Apply
“About Rules for Controlling the Behavior of Capture, Propagation, and Apply”
About Rule-Based Transformations for Nonidentical Copies
“About Rule-Based Transformations for Nonidentical Copies”
About Supplemental Logging
“About Supplemental Logging”
About Conflicts and Conflict Resolution
“About Conflicts and Conflict Resolution”
About Tags for Avoiding Change Cycling
“About Tags for Avoiding Change Cycling”
About the Common Types of Oracle Streams Replication Environments
“About the Common Types of Oracle Streams Replication Environments”
About Two-Database Replication Environments
“About Two-Database Replication Environments”
One-Way Replication in a Two-Database Replication Environment
“One-Way Replication in a Two-Database Replication Environment”
Bi-Directional Replication in a Two-Database Replication Environment
“Bi-Directional Replication in a Two-Database Replication Environment”
About Hub-And-Spoke Replication Environments
“About Hub-And-Spoke Replication Environments”
Hub-and-Spoke Replication Environment with Read-Only Spokes
“Hub-and-Spoke Replication Environment with Read-Only Spokes”
Hub-and-Spoke Replication Environment with Read/Write Spokes
“Hub-and-Spoke Replication Environment with Read/Write Spokes”
About N-Way Replication Environments
“About N-Way Replication Environments”
N-Way Replication Environment
“N-Way Replication Environment”
About Key Oracle Streams Supplied PL/SQL Packages and Data Dictionary Views
“About Key Oracle Streams Supplied PL/SQL Packages and Data Dictionary Views”
About Key Oracle Streams Supplied PL/SQL Packages
“About Key Oracle Streams Supplied PL/SQL Packages”
Key Oracle Streams Supplied PL/SQL Packages
“Key Oracle Streams Supplied PL/SQL Packages”
About Key Oracle Streams Data Dictionary Views
“About Key Oracle Streams Data Dictionary Views”
Key Oracle Streams Data Dictionary Views
“Key Oracle Streams Data Dictionary Views”
Preparing for Oracle Streams Replication
“Preparing for Oracle Streams Replication”
Configuring Oracle Streams Replication: Examples
“Configuring Oracle Streams Replication: Examples”
Tutorial: Configuring Two-Database Replication with Local Capture Processes
“Tutorial: Configuring Two-Database Replication with Local Capture Processes”
Two-Database Replication Environment with Local Capture Processes
“Two-Database Replication Environment with Local Capture Processes”
Tutorial: Configuring Two-Database Replication with a Downstream Capture Process
“Tutorial: Configuring Two-Database Replication with a Downstream Capture Process”
Two-Database Replication Environment with a Downstream Capture Process
“Two-Database Replication Environment with a Downstream Capture Process”
Tutorial: Configuring Hub-and-Spoke Replication with Local Capture Processes
“Tutorial: Configuring Hub-and-Spoke Replication with Local Capture Processes”
Hub-and-Spoke Environment with Capture Processes and Read/Write Spokes
“Hub-and-Spoke Environment with Capture Processes and Read/Write Spokes”
Tutorial: Configuring Two-Database Replication with Synchronous Captures
“Tutorial: Configuring Two-Database Replication with Synchronous Captures”
Two-Database Replication Environment with Synchronous Captures
“Two-Database Replication Environment with Synchronous Captures”
Tutorial: Configuring Latest Time Conflict Resolution for a Table
“Tutorial: Configuring Latest Time Conflict Resolution for a Table”
Administering an Oracle Streams Replication Environment
“Administering an Oracle Streams Replication Environment”
Managing an Oracle Streams Replication Environment
“Managing an Oracle Streams Replication Environment”
Managing Capture Processes
“Managing Capture Processes”
Starting and Stopping a Capture Process
“Starting and Stopping a Capture Process”
Setting a Capture Process Parameter
“Setting a Capture Process Parameter”
Enabling and Disabling a Propagation
“Enabling and Disabling a Propagation”
Managing Apply Processes
“Managing Apply Processes”
Starting and Stopping an Apply Process
“Starting and Stopping an Apply Process”
Setting an Apply Process Parameter
“Setting an Apply Process Parameter”
Monitoring an Oracle Streams Replication Environment
“Monitoring an Oracle Streams Replication Environment”
Displaying an Overview of the Replication Components at a Database
“Displaying an Overview of the Replication Components at a Database”
Displaying the Stream Paths
“Displaying the Stream Paths”
Displaying Performance Analysis Information for Oracle Streams Components
“Displaying Performance Analysis Information for Oracle Streams Components”
Displaying the Topology of the Oracle Streams Environment at a Database
“Displaying the Topology of the Oracle Streams Environment at a Database”
Monitoring Capture Processes
“Monitoring Capture Processes”
Viewing Information About a Capture Process
“Viewing Information About a Capture Process”
Viewing Statistics for a Capture Process
“Viewing Statistics for a Capture Process”
Viewing Active Capture Process Transactions
“Viewing Active Capture Process Transactions”
Monitoring Propagations
“Monitoring Propagations”
Viewing Information About a Propagation
“Viewing Information About a Propagation”
Viewing Statistics for a Propagation
“Viewing Statistics for a Propagation”
Monitoring Apply Processes
“Monitoring Apply Processes”
Viewing Information About an Apply Process
“Viewing Information About an Apply Process”
Viewing Statistics for an Apply Process
“Viewing Statistics for an Apply Process”
Viewing Active and Spilled Apply Process Transactions
“Viewing Active and Spilled Apply Process Transactions”
Displaying the Configured Update Conflict Handlers
“Displaying the Configured Update Conflict Handlers”
Viewing Buffered Queue Statistics
“Viewing Buffered Queue Statistics”
Displaying the Amount of Time Between Capture and Apply
“Displaying the Amount of Time Between Capture and Apply”
Troubleshooting an Oracle Streams Replication Environment
“Troubleshooting an Oracle Streams Replication Environment”
Responding to Automated Alerts in Enterprise Manager
“Responding to Automated Alerts in Enterprise Manager”
Oracle Streams Alerts
“Oracle Streams Alerts”
Capture Aborts Alert
“Capture Aborts Alert”
Response
“Response”
Propagation Aborts Alert
“Propagation Aborts Alert”
Response
“Response”
Apply Aborts Alert
“Apply Aborts Alert”
Response
“Response”
Apply Error Alert
“Apply Error Alert”
Response
“Response”
Oracle Streams Pool Alert
“Oracle Streams Pool Alert”
Response
“Response”
Managing Apply Errors
“Managing Apply Errors”
Correcting Apply Errors in Database Objects
“Correcting Apply Errors in Database Objects”
Retrying or Deleting Apply Error Transactions
“Retrying or Deleting Apply Error Transactions”
Managing a Replication Environment When a Destination Is Unavailable
“Managing a Replication Environment When a Destination Is Unavailable”
Extending an Oracle Streams Replication Environment
“Extending an Oracle Streams Replication Environment”
About Extending an Oracle Streams Replication Environment
“About Extending an Oracle Streams Replication Environment”
Use the Setup Streams Replication Wizard or a Single Configuration Procedure
“Use the Setup Streams Replication Wizard or a Single Configuration Procedure”
Add the Oracle Streams Components Individually in Multiple Steps
“Add the Oracle Streams Components Individually in Multiple Steps”
Tutorial: Adding Database Objects to a Replication Environment
“Tutorial: Adding Database Objects to a Replication Environment”
Tutorial: Adding Databases to a Replication Environment
“Tutorial: Adding Databases to a Replication Environment”
Replicating Data Using Materialized Views
“Replicating Data Using Materialized Views”
About Materialized View Replication
“About Materialized View Replication”
About Master Sites, Master Tables, and Materialized View Sites
“About Master Sites, Master Tables, and Materialized View Sites”
About Materialized View Refresh
“About Materialized View Refresh”
About Refresh Groups
“About Refresh Groups”
Preparing for Materialized View Replication
“Preparing for Materialized View Replication”
Configuring Materialized View Sites
“Configuring Materialized View Sites”
Configuring Materialized View Logs at the Master Site
“Configuring Materialized View Logs at the Master Site”
Replicating Read-Only Data Using Materialized Views
“Replicating Read-Only Data Using Materialized Views”
About Replicating Read-Only Data Using Materialized Views
“About Replicating Read-Only Data Using Materialized Views”
Read-Only Materialized View
“Read-Only Materialized View”
Tutorial: Configuring Read-Only Data Replication Using Materialized Views
“Tutorial: Configuring Read-Only Data Replication Using Materialized Views”
Replicating Read/Write Data Using Materialized Views
“Replicating Read/Write Data Using Materialized Views”
About Replicating Read/Write Data Using Materialized Views
“About Replicating Read/Write Data Using Materialized Views”
Updatable Materialized View
“Updatable Materialized View”
About Replication Groups and Updatable Materialized Views
“About Replication Groups and Updatable Materialized Views”
Materialized View Groups Correspond with Master Groups
“Materialized View Groups Correspond with Master Groups”
Refresh Groups Can Contain Objects from Multiple Materialized View Groups
“Refresh Groups Can Contain Objects from Multiple Materialized View Groups”
About Scheduled Links and Deferred Transactions
“About Scheduled Links and Deferred Transactions”
About Conflicts and Updatable Materialized Views
“About Conflicts and Updatable Materialized Views”
Configuring Replication of Read/Write Data Using Materialized Views
“Configuring Replication of Read/Write Data Using Materialized Views”
Configuring a Refresh Group
“Configuring a Refresh Group”
Administering a Materialized View Replication Environment
“Administering a Materialized View Replication Environment”
Managing a Materialized View Replication Environment
“Managing a Materialized View Replication Environment”
Refreshing Materialized Views
“Refreshing Materialized Views”
Refreshing a Refresh Group
“Refreshing a Refresh Group”
Refreshing a Materialized View
“Refreshing a Materialized View”
Adding Materialized Views to a Refresh Group
“Adding Materialized Views to a Refresh Group”
Dropping a Materialized View
“Dropping a Materialized View”
Tutorial: Cleaning Up Materialized View Support at a Master Site
“Tutorial: Cleaning Up Materialized View Support at a Master Site”
Monitoring a Materialized View Replication Environment
“Monitoring a Materialized View Replication Environment”
Viewing an Overview of the Replication Components at a Database
“Viewing an Overview of the Replication Components at a Database”
Viewing Information About Materialized Views
“Viewing Information About Materialized Views”
Determining Which Materialized Views Are Currently Refreshing
“Determining Which Materialized Views Are Currently Refreshing”
Viewing Information About Materialized View Groups
“Viewing Information About Materialized View Groups”
Viewing Information About Deferred Transactions for Updatable Materialized Views
“Viewing Information About Deferred Transactions for Updatable Materialized Views”
Viewing Information About Refresh Groups
“Viewing Information About Refresh Groups”
Viewing Materialized View Logs at a Master Site
“Viewing Materialized View Logs at a Master Site”
Viewing the Materialized Views for a Master Site
“Viewing the Materialized Views for a Master Site”
Troubleshooting a Materialized View Replication Environment
“Troubleshooting a Materialized View Replication Environment”
Correcting Problems with Materialized View Refresh
“Correcting Problems with Materialized View Refresh”
Preventing Materialized View Logs From Becoming Too Large
“Preventing Materialized View Logs From Becoming Too Large”
Sending Messages Using Oracle Streams Advanced Queuing
“Sending Messages Using Oracle Streams Advanced Queuing”
About Messaging
“About Messaging”
About Message Ordering
“About Message Ordering”
About Message Modes
“About Message Modes”
About Message Notifications
“About Message Notifications”
About Propagations
“About Propagations”
About Oracle Messaging Gateway
“About Oracle Messaging Gateway”
Preparing for Messaging
“Preparing for Messaging”
Tutorial: Sending Messages Between Oracle Databases
“Tutorial: Sending Messages Between Oracle Databases”
Sample Messaging Environment That Sends Messages Between Databases
“Sample Messaging Environment That Sends Messages Between Databases”
Task 1: Creating the Message Type at Each Database
“Task 1: Creating the Message Type at Each Database”
Task 2: Configuring the Queues and Propagation Between Them
“Task 2: Configuring the Queues and Propagation Between Them”
Task 3: Configuring a Message Enqueuing Mechanism
“Task 3: Configuring a Message Enqueuing Mechanism”
Task 4: Configuring a Messaging Client to Dequeue Messages
“Task 4: Configuring a Messaging Client to Dequeue Messages”
Task 5: Enqueuing Messages
“Task 5: Enqueuing Messages”
Task 6: Dequeuing Messages
“Task 6: Dequeuing Messages”
Tutorial: Configuring Message Notifications
“Tutorial: Configuring Message Notifications”
Sample Messaging Environment That Uses Message Notification
“Sample Messaging Environment That Uses Message Notification”
Task 1: Creating the Message Type
“Task 1: Creating the Message Type”
Task 2: Configuring a Queue and a Messaging Client
“Task 2: Configuring a Queue and a Messaging Client”
Task 3: Configuring a Mechanism for Dequeuing Messages
“Task 3: Configuring a Mechanism for Dequeuing Messages”
Task 4: Configuring Message Notification
“Task 4: Configuring Message Notification”
Task 5: Enqueuing Messages and Checking for Message Notification
“Task 5: Enqueuing Messages and Checking for Message Notification”
Modifying Queues
“Modifying Queues”
Modifying Queue Tables
“Modifying Queue Tables”
Modifying Propagations
“Modifying Propagations”
Monitoring a Messaging Environment
“Monitoring a Messaging Environment”
Viewing the Messages in a Queue
“Viewing the Messages in a Queue”
Viewing Persistent Queue Statistics
“Viewing Persistent Queue Statistics”
Viewing the Consumers Who Can Dequeue Messages
“Viewing the Consumers Who Can Dequeue Messages”
Troubleshooting a Messaging Environment
“Troubleshooting a Messaging Environment”
Correcting an ORA-01031 Error While Enqueuing or Dequeuing Messages
“Correcting an ORA-01031 Error While Enqueuing or Dequeuing Messages”
Correcting an ORA-24033 Error While Enqueuing Messages
“Correcting an ORA-24033 Error While Enqueuing Messages”
Correcting an ORA-02019 Error for a Propagation
“Correcting an ORA-02019 Error for a Propagation”
Understanding Why Dequeued Messages Remain in a Queue
“Understanding Why Dequeued Messages Remain in a Queue”
Comparing and Converging Data
“Comparing and Converging Data”
About Comparing and Converging Data in Different Databases
“About Comparing and Converging Data in Different Databases”
Tutorial: Preparing to Compare and Converge Data
“Tutorial: Preparing to Compare and Converge Data”
Tutorial: Comparing Data in Two Different Databases
“Tutorial: Comparing Data in Two Different Databases”
Tutorial: Converging Divergent Data
“Tutorial: Converging Divergent Data”