Skip Navigation

Oracle Database Online Documentation 11g Release 2 (11.2)

Information Integration

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

Essentials

Covers using Oracle Streams, materialized views, and other distributed database functionality
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

XStream

XStream provides APIs that enable client applications to send and receive data changes between Oracle databases and between Oracle and non-Oracle data sources.
Contains conceptual information and reference information about XStream. Also contains instructions for using XStream. The reference information includes descriptions of the OCI API for XStream, PL/SQL packages related to XStream, and data dictionary views related to XStream.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes the Java APIs for XStream.
No other download option available.
Download As...

Oracle Streams

Oracle Streams enables information sharing, including data replication and message queuing, within or between databases.

Contains conceptual information about Oracle Streams and information about administering, monitoring, and troubleshooting an Oracle Streams environment. It also contains instructions for using Oracle Streams to record table changes. It also contains conceptual information about information provisioning and instructions for using Oracle Streams for information provisioning. It also includes instructions for using Oracle Streams for database upgrades and database maintenance operations.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Contains instructions for configuring and managing an Oracle Streams replication environment. It also includes best practices for Oracle Streams replication environments and instructions for migrating from Advanced Replication to Oracle Streams replication.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes features of application development and integration using Oracle Streams Advanced Queuing (AQ). This information applies to versions of the Oracle Database server that run on all platforms, unless otherwise specified.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Contains extended examples that configure various types of Oracle Streams environments.
Download As...

Mobi for Kindle

ePub for iBooks and mobile devices

Describes the packages provided with the Oracle database server. The manual is intended for programmers, systems analysts, project managers, and others interested in developing database applications.
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 the Oracle Database Gateway for Adabas, which enables Oracle client applications to access Adabas data through Structured Query Language (SQL).
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides Oracle Database Gateway installation and configuration information.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Assists in determining hardware and software requirements, installing, configuring, or administering an Oracle Database Gateway for APPC, developing applications that access remote host databases through the gateway using either the SNA communication protocol or the TCP/IP for IMS Connect communication protocol, determining security requirements, and determining and resolving problems.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Assists in determining hardware and software requirements, installing, configuring, or administering an Oracle Database Gateway for APPC, developing applications that access remote host databases through the Oracle Database Gateway for APPC using the SNA Communication Protocol or the TCP/IP communication protocol, determining security requirements, and determining and resolving problems.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides users with transparent access to DB2.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes the Oracle Database Gateway for ODBC, which enables Oracle client applications to access non-Oracle systems data through Structured Query Language (SQL).
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides Oracle Database Gateway installation and configuration information.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Assists Oracle database administrators who are responsible for installing, configuring the components of the Oracle Database Gateway for IMS, VSAM, and Adabas and for diagnosing gateway errors.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes the Oracle Database Gateway for Informix, which enables Oracle client applications to access Informix data through Structured Query Language (SQL).
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes the Oracle Database Gateway for ODBC, which enables Oracle client applications to access non-Oracle systems data through Structured Query Language (SQL).
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes the Oracle Database Gateway for SQL Server, which enables Oracle client applications to access SQL Server data through Structured Query Language (SQL).
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes the Oracle Database Gateway for Sybase, which enables Oracle client applications to access Sybase data through Structured Query Language (SQL).
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes the Oracle Database Gateway for Teradata, which enables Oracle client applications to access Teradata data through Structured Query Language (SQL).
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes the Oracle Database Gateway for Adabas, which enables Oracle client applications to access Adabas data through Structured Query Language (SQL).
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 64Ebit applications.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides Oracle Database Gateway installation and configuration information.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Assists Oracle database administrators who are responsible for installing and configuring Oracle Database Gateways.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes the installation and configuration of Oracle Connect for IMS, VSAM, and Adabas Gateways, a prebuilt driver to mainframe data.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes Oracle's approach to information integration in a heterogeneous environment. Describes Oracle Database Gateways and is a user's guide for these Oracle products.
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.

Contains conceptual information about Oracle Database Advanced Replication. It also includes information about planning an Advanced Replication environment and information about troubleshooting Advanced Replication problems.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Contains reference information about and step-by-step instructions for using the replication management API, which is a set of PL/SQL packages for setting up and managing an Advanced Replication environment. It also includes reference information about data dictionary views that are important for Advanced Replication and security considerations for an Advanced Replication environment.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Network Management

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

Explains how to plan, configure, and manage enterprise-wide connectivity with Oracle Net Services.
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

Describes how to create, configure, and administer an Oracle database. Includes sections on Oracle Scheduler, Oracle Database Resource Manager, Oracle Restart, and distributed computing.
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.

Describes how to create, configure, and administer an Oracle database. Includes sections on Oracle Scheduler, Oracle Database Resource Manager, Oracle Restart, and distributed computing.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

This book describes how to develop, load, and run Java applications in Oracle Database.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to use Oracle Database utilities to load data into a database, transfer data between databases, and maintain data. The topics discussed include Data Pump Export, Data Pump Import, SQL*Loader, external tables and associated access drivers, the Automatic Diagnostic Repository Command Interpreter (ADRCI), DBVERIFY, DBNEWID, LogMiner, the Metadata API, original Export, and original Import.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Explains how to create, configure, and manage Oracle Database on Linux and UNIX-based operating systems.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices