Oracle Database Online Documentation
10g Release 2 (10.2)
Information Integration
Oracle Streams
Oracle Streams lets you move data within or between databases:
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
Describes the features and functionality of Streams that can be used for data replication. This document contains conceptual information about Streams replication, along with information about configuring and managing a Streams replication environment.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
Describes features of application development and integration using the Oracle messaging system, Advanced Queuing . Includes the PL/SQL, C, Visual Basic, Java, and JMS interfaces to AQ and gateways to non-Oracle messaging systems.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
Describes the features and functionality of Streams. This document contains conceptual information about Streams, along with information about managing a Streams environment. In addition, this document contains detailed examples that configure a Streams capture and apply environment and a rule-based application.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)
Workflow
Oracle Workflow lets you define and execute business processes, such as approvals and notifications.
Network Management
Oracle Net helps you manage connectivity, security, and performance across both Internet and intranet networks:
Additional Features
Other Information Integration features, such as transportable tablespaces, Data Pump, and Web services, are covered in these books.
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
Provides a general overview on how to develop, load, and execute Java applications in the database.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)
Download As...
PDF for offline viewing
Advanced Replication
Replication copies data so that you always have a backup copy, either as a standby database or to run queries:
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
Describes the features and functionality of Advanced Replication. Specifically, Oracle Database Advanced Replication contains conceptual information about Advanced Replication, as well as information about planning your replication environment and troubleshooting replication problems. Oracle Database Advanced Replication also contains an introduction to the Replication Management tool in the Oracle Enterprise Manager Console.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
Describes the features and functionality of the replication management API. Specifically, the Oracle Database Advanced Replication Management API Reference contains reference information for the packages in the replication management API, as well as examples of their use.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)
Heterogeneous Connectivity
You can integrate data from non-Oracle database systems with data that resides in an Oracle database:
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
Describes Oracle's approach for information integration in a heterogeneous environment. Specifically, it describes Oracle Transparent Gateways and Generic Connectivity and is meant to be an administrator's guide for these Oracle products.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
Provides Oracle applications seamless access to virtually any APPC-enabled system, including IBM mainframe data and services through Remote Procedure Call processing. This document is intended for Windows users.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
The Oracle Procedural Gateway Visual Workbench for WebSphere MQ, is a development tool that simplifies integrating Oracle applications with non-Oracle message queuing applications. It is used by developers who write Oracle applications that communicate with non-Oracle messaging and queuing applications, using a procedural gateway for a message queuing system.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
Describes the Oracle Transparent Gateway for Informix, which enables Oracle client applications to access Informix data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
Describes the Oracle Transparent Gateway for Informix, which enables Oracle client applications to access Informix data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
Describes the Oracle Transparent Gateway for Ingres II, which enables Oracle client applications to access Ingres II data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
Describes the Oracle Transparent Gateway for Ingres II, which enables Oracle client applications to access Ingres II data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
Describes the Oracle Transparent Gateway for Microsoft SQL Server, which enables Oracle client applications to access Microsoft SQL Server data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
Describes the Oracle Transparent Gateway for Sybase, which enables Oracle client applications to access Sybase data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
Describes the Oracle Transparent Gateway for Sybase, which enables Oracle client applications to access Sybase data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
Describes the Oracle Transparent Gateway for Sybase, which enables Oracle client applications to access Sybase data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
Describes the Oracle Transparent Gateway for Sybase, which enables Oracle client applications to access Sybase data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
Describes the Oracle Transparent Gateway for Sybase, which enables Oracle client applications to access Sybase data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
Describes the Oracle Transparent Gateway for Teradata, which enables Oracle client applications to access Teradata data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
Describes the Oracle Transparent Gateway for Teradata, which enables Oracle client applications to access Teradata data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)
![Click to show summary. Click to show summary.](../dcommon/img/icn-16-info.png)
Describes the Oracle Transparent Gateway for Teradata, which enables Oracle client applications to access Teradata data through Structured Query Language. The gateway, with the Oracle database server, creates the appearance that all data resides on a local Oracle database server, even though the data can be widely distributed.
![Click to show download options. Click to show download options.](../dcommon/img/icn-16-download.png)