Skip Navigation

Oracle Database Online Documentation 11g Release 1 (11.1)

Information Integration

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

Essentials

Contains conceptual information about Oracle Streams replication and about configuring, administering, and monitoring an Oracle Streams replication environment. Also includes detailed examples of configuring Oracle Streams replication environments.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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 configuring, administering, and monitoring an Oracle Streams environment. Also includes detailed examples of using Oracle Streams for various purposes.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Contains conceptual information about Oracle Streams replication and about configuring, administering, and monitoring an Oracle Streams replication environment. Also includes detailed examples of configuring Oracle Streams replication environments.
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 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 the Oracle approach to information integration in a heterogeneous environment. Describes Oracle Database Gateways and is an administrator's guide for these Oracle products.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Contains important information that was not included in the platform-specific or product-specific documentation for this release.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides important information that was not included in the platform-specific or product-specific documentation for this release.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to install and configure Oracle Database Gateway for Sybase, Informix, Teradata, Microsoft SQL Server, and ODBC on UNIX based platforms.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to install Oracle Database Gateway for Sybase, Informix, Teradata, SQL Server, ODBC, and DRDA on Microsoft Windows (32-bit) platform.
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 SQL Server, which enables Oracle client applications to access 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 Database Gateway for ODBC, which enables Oracle client applications to access non-Oracle systems data through Structured Query Language (SQL). The gateway, with the Oracle database, creates the appearance that all data resides on a local Oracle database, 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 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 installing, configuring, and administring the gateway. Specifically: - Installing and configuring the Oracle Database Gateway for DRDA - Configuring the SNA and TCP/IP products - Setting up gateway security - Diagnosing gateway errors - Using the gateway to access tables in DRDA databases - Writing applications that access DRDA databases through the gateway
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to install, configure, or administer the Oracle Database Gateway for WebSphere MQ. Specifically: - Administering the gateway - Setting up gateway security - Using the gateway - Diagnosing gateway errors
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides information on 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, determining and resolving problems.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides information on 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, determining and resolving problems.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to use Oracle Database Gateway for APPC. Specifically: - 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 - Determining and resolving problems
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes the installation and configuration of Oracle Transparent Gateway for IMS, VSAM, and Adabas, which enables Oracle client applications to access IMS, VSAM, and Adabas data through Structured Query Language (SQL). The gateway, with the Oracle Database, creates the appearance that all data is located on a local Oracle Database, 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 installation and configuration of Oracle Database Gateway for IMS, VSAM, and Adabas, which enables Oracle client applications to access IMS, VSAM, and Adabas data through Structured Query Language (SQL). The gateway, with the Oracle Database, creates the appearance that all data is located on a local Oracle Database, 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 installation and configuration of Oracle Connect for IMS, VSAM, and Adabas Gateways, a prebuilt driver to mainframe data. Oracle Connect for IMS, VSAM, and Adabas Gateways is located natively on the data server to provide standard, service-oriented integration to data sources on z/OS platforms. With robust support for metadata, bi-directional read/write access, and transaction management, Oracle Connect for IMS, VSAM, and Adabas Gateways simplifies and reduces the cost of legacy integration.
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

Describes the Oracle Database Gateway for IMS, which enables Oracle client applications to access IMS 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 VSAM, which enables Oracle client applications to access VSAM data through Structured Query Language (SQL)
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 Advanced Replication. Also includes information about planning an Advanced Replication environment, an introduction to the Replication Management tool in Oracle Enterprise Manager, 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. 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

Additional Features

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

Explains how to create, administer, and monitor an Oracle database. Includes information about distributed processing and Oracle Scheduler.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides platform-specific information about administering and configuring Oracle Database 11g release 1 (11.1)
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

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 utilities described include the new Data Pump export and import products, the original export and import products, SQL*Loader, external tables, the Metadata API, LogMiner, DBVERIFY, and DBNEWID.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices