Skip Navigation

Oracle Database Online Documentation
10g Release 2 (10.2)

Information Integration

Information Integration

To take full advantage of your data, you might need to move it, transform it, and combine data from multiple sources.

Oracle Streams

Oracle Streams lets you move data within or between databases:

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.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes the PL/SQL packages and defined types supplied with Oracle Database. Packages are listed alphabetically with syntax, procedures and functions, and parameters described for each package.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides reference information about database initialization parameters, static data dictionary views, dynamic performance views, database limits, and SQL scripts that are part of the Oracle Database.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Workflow

Oracle Workflow lets you define and execute business processes, such as approvals and notifications.

Describes the APIs used by Oracle Workflow.
Download As...

PDF for offline viewing

Describes how to develop applications using Oracle Workflow.
Download As...

PDF for offline viewing

Describes how to use Oracle Workflow.
Download As...

PDF for offline viewing

No summary available.
No summary available.
Download As...

PDF for offline viewing

Network Management

Oracle Net helps you manage connectivity, security, and performance across both Internet and intranet networks:

Provides the information you need to understand and use Oracle Net Services and its related applications and components.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Contains a complete listing and description of the control utility commands and configuration file parameters available for managing components of Oracle Net Services.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Additional Features

Other Information Integration features, such as transportable tablespaces, Data Pump, and Web services, are covered in these books.

No summary available.
No summary available.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

No summary available.
No summary available.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides information about administering and configuring Oracle Database 10g release 2 (10.2).
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides a general overview on how to develop, load, and execute Java applications in the database.
Download As...

PDF for offline viewing

Describes how to use the Oracle Database utilities for data transfer, data maintenance, and database administration.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Advanced Replication

Replication copies data so that you always have a backup copy, either as a standby database or to run queries:

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.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes the PL/SQL packages and defined types supplied with Oracle Database. Packages are listed alphabetically with syntax, procedures and functions, and parameters described for each package.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides reference information about database initialization parameters, static data dictionary views, dynamic performance views, database limits, and SQL scripts that are part of the Oracle Database.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Heterogeneous Connectivity

You can integrate data from non-Oracle database systems with data that resides in an Oracle database:

Describes how to install, configure, and use the Oracle Access Manager for AS/400 software on the IBM iSeries.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes installing, configuring, and administering the Oracle Transparent Gateway for DB2/400 on the IBM iSeries OS/400 platform.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides Oracle applications with seamless access to IBM mainframe data and services through Remote Procedure Call processing.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides Oracle applications with seamless access to IBM mainframe data and services through Remote Procedure Call processing.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Contains messages for all Oracle Procedural Gateway for APPC products. Use it with the Oracle Database Server Messages manual.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides Oracle applications seamless access to virtually any APPC-enabled system, including IBM mainframe data and services through Remote Procedure Call processing.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides access to WebSphere MQ services.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides access to WebSphere MQ services. This gateway requires a system that is capable of running 64-bit applications.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides instructions for administering and configuring Oracle Transparent Gateway for DB2 for 10g Release 2 (10.2) for z/OS.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides users with transparent access to DRDA databases as if they were Oracle databases.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides users with transparent access to DRDA databases as if they were Oracle databases.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to install Oracle Transparent Gateway for Microsoft Windows (32-bit).
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to install Oracle Transparent Gateway for Solaris Operating System, hp-ux, IBM AIX, and hp Tru64 UNIX.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices