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