4
Oracle9i Documentation

This chapter lists the generic books available online (that is, the books not specific to a particular operating system) that document the Oracle9i Database, release 2.

This chapter contains the following sections:

Online Documentation Structure

All books are available in electronic format. The following categories of documentation are available:

Documentation Titles

The following tables list the book titles in the generic documentation areas. All documentation is available in PDF only.

Note:

This is the list of books and part numbers that were available at release time. This list might differ slightly from what is available online.

Oracle9i Master Index and Master Glossary

Table 4-1 Oracle9i Master Index and Master Glossary

Documentation	Part Number	Description
Oracle9i Database Generic Documentation Master Glossary	A92001	Defines terms used in Oracle9i database documentation.
Oracle9i Generic Documentation Master Index	A96625	Lists and provides links to contexts for terms that appear in Oracle9i database documentation.

Oracle9i Server and SQL*Plus

***Table 4-2 Oracle9i Server and SQL*Plus Documentation***

Documentation	Part Number	Description
Administration, Concepts, and Reference
Oracle9i Database New Features	A96531	Explains new features of Oracle9i. Also describes and lists documentation for this release.
Oracle9i Database Administrator's Guide	A96521	Explains how to create and to manage an Oracle database. Includes information about distributed processing.
Oracle9i Database Concepts	A96524	Describes how the Oracle server functions and lays a conceptual foundation for information contained in other Oracle server manuals.
Oracle9i Database Error Messages	A96526	Lists Oracle Database error and informational messages and provides their corresponding cause and action statements.
Oracle9i Database Migration	A96530	Explains how to plan and execute migrations, upgrades, and downgrades of an Oracle database system. Also provides information about compatibility, about upgrading applications to the current release of Oracle, and about important changes in the current release, including initialization parameter changes and data dictionary changes.
Oracle9i Database Performance Tuning Guide and Reference	A96533	Explains in detail how to enhance Oracle performance by writing and tuning SQL properly, by using performance tools, and by optimizing instance performance. Also explains how to create an initial database for good performance and includes performance-related reference information.
Oracle9i Database Performance Planning	A96532	Explains the high-level performance methodology recommended by Oracle for the database. Explains clear and simple activities that can dramatically improve system performance according to extensive oracle designing and performance research.
Oracle9i Database Reference	A96536	Provides reference information about database initialization parameters, static data dictionary views, dynamic performance views, database limits, and SQL scripts.
Oracle9i Database Utilities	A96652	The Oracle Database Utilities manual describes how to use Oracle Database utilities to load data into a database, transfer data between databases, and maintain data. Specific utilities discussed are Export, Import, SQL*Loader, External Tables, DBVERIFY, and DBNEWID. Also describes the Oracle9i external tables feature, which enables you to access data in external sources as if it were in a table in the database.
Oracle9i Database Globalization Support Guide	A96529	Describes Oracle's globalization support and how to use its capabilities.
Oracle9i Sample Schemas	A96539	Describes the four schemas that are included in the seed database that ships, along with the familiar `SCOTT` schema, with Oracle9i. These schemas are used in many examples in the documentation.
Oracle9i SQL Reference	A96540	Contains a complete description of the Structured Query Language (SQL) used to manage information in an Oracle database. The first volume describes all of the building blocks of SQL statements. The remaining volumes describe the SQL statements alphabetically.
Oracle9i Heterogeneous Connectivity Administrator's Guide	A96544	Describes Oracle's approach for heterogeneous connectivity and provides information for its use.
Backup and Recovery
Oracle9i Backup and Recovery Documentation Online Roadmap	A97202	Lays out the structure of the various Oracle9i Backup and Recovery documents and the recommended order in which you should read them.
Oracle9i Backup and Recovery Concepts	A96519	Describes the basic concepts involved in backup and recovery.
Oracle9i Recovery Manager User's Guide	A96566	Describes how to use Recovery Manager (RMAN) to perform backup and recovery.
Oracle9i Recovery Manager Reference	A96565	This book describes the RMAN syntax and recovery catalog views.
Oracle9i Recovery Manager Quick Reference	A96564	This quick reference manual describes the basic RMAN tasks and syntax.
Oracle9i User-Managed Backup and Recovery Guide	A96572	This book describes how to use operating system commands to perform backup and restore operations, and SQL*Plus to perform recovery.
Data Warehousing
Oracle9i Data Warehousing Guide	A96520	Provides reference and implementation material for using Oracle9i in data warehouses.
Streams and Replication
Oracle9i Streams	A96571	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.
Oracle9i Replication	A96567	Contains conceptual information about Oracle replication. Also includes information about planning a replication environment, an introduction to the Replication Management tool in Oracle Enterprise Manager, descriptions of the new replication features in the current release, and information about troubleshooting replication problems.
Oracle9i Replication Management API Reference	A96568	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 a replication environment. Also includes reference information about data dictionary views that are important for replication and security considerations for a replication environment.
*SQLPlus**
SQLPlus User's Guide and Reference*	A90842	Introduces the SQLPlus tool. Introductory and How to sections describe the SQLPlus Command Line and iSQLPlus user interfaces and how to configure and use them. Reference and Error sections provide SQLPlus command descriptions and a list of SQL*Plus error messages with associated cause and action text.
SQLPlus Quick Reference*	A90843	Shows the syntax for SQL*Plus commands.
SQLPlus Getting Started for Windows*	A92157	Describes features specific to the Windows operating system including the Windows user interface to SQL*Plus.
Data Guard
Oracle9i Data Guard Broker	A96629	Describes the Oracle9i Data Guard broker, a management and monitoring interface that automates many of the tasks involved in configuring and monitoring standby databases in an Oracle9i Data Guard configuration. This guide provides comprehensive descriptions and examples for using both the command-line interface and the Oracle9i Data Guard Manager graphical user interface.
Oracle9i Data Guard Concepts and Administration	A96653	Provides a comprehensive overview of Oracle9i Data Guard concepts and describes how to configure and implement standby databases that can take over production operations if your production database becomes unusable. This guide includes several common database scenarios such as creating, recovering, failing over, switching over, configuring, and backing up standby and primary databases.

Oracle9i Directory, Networking, and Security Documentation

Table 4-3 Oracle9i Directory, Networking, and Security Documentation

Documentation	Part Number	Description
Networking and Security
Oracle9i Net Services Administrator's Guide	A96580	Explains how to plan, configure, and manage enterprise-wide connectivity with Oracle Net Services.
Oracle9i Net Services Reference Guide	A96581	Explains how to plan, configure, and manage enterprise-wide connectivity with Oracle Net Services.
Oracle Advanced Security Administrator's Guide	A96573	Oracle Advanced Security provides a single source of integration with network encryption, single sign-on services, smartcard, token and biometric user authentication.
Oracle Label Security Administrator's Guide	A96578	Describes how to use Oracle Label Security to protect sensitive data. It explains the basic concepts behind label-based security and provides examples to show how it is used.
Oracle9i Security Overview	A96582	Introduces the basic concepts of system security. It outlines the data security risks which are prevalent today, and the industry-standard technologies available to address them. It then presents the suite of Oracle products you can use to implement these security technologies.
Oracle Internet Directory
Oracle Internet Directory Administrator's Guide	A96574	Describes the features, architecture, and administration of Oracle Internet Directory.
Oracle Internet Directory Application Developer's Guide	A96577	Provides information for enabling applications to access Oracle Internet Directory by using the C API and the PL/SQL API.
Oracle9i Directory Service Integration and Deployment Guide	A96579	A starting point for those who want to learn how Oracle products use Oracle Internet Directory. Covers LDAP concepts and baseline directory configuration tasks.

Oracle9i Real Application Clusters

Table 4-4 Oracle9i Real Application Clusters Documentation

Documentation	Part Number	Description
Oracle9i Real Application Clusters Documentation Online Roadmap	A96599	Lays out the structure of the various Real Application Clusters documents and the recommended order in which you should read them.
Oracle9i Real Application Clusters Concepts	A96597	Provides a conceptual description of Real Application Clusters processing and the Real Application Clusters architecture.
Oracle9i Real Application Clusters Setup and Configuration	A96600	Explains Real Application Clusters setup and configuration procedures as well as how to use Oracle tools for software installation and database creation.
Oracle9i Real Application Clusters Administration	A96596	Explains how to administer Real Application Clusters.
Oracle9i Real Application Clusters Deployment and Performance	A96598	Provides a high-level explanation of deployment practices for various system types such as e-commerce, data warehousing, and online transaction processing. Gives an in-depth examination of Real Application Clusters performance measurement and tuning methods to maximize clustered environment performance.
Oracle9i Real Application Clusters Real Application Clusters Guard I - Concepts and Administration	A96601	Describes configuration parameters, and explains how to set up customized features, how to use the command-line interface, how to set up the network configuration, and how to troubleshoot Oracle Real Application Clusters Guard I.

Oracle9i Database Application Development

Table 4-5 Oracle9i Database Application Development Documentation

Documentation	Part Number	Description
Application Development
Oracle9i Application Developer's Guide - Fundamentals	A96590	Introduces the features needed to develop applications for Oracle9i, particularly triggers and stored procedures. This book also gives a high-level overview of topics covered in more detail in other books, such as PL/SQL, Java, and OCI.
Oracle9i Application Developer's Guide - Advanced Queuing	A96587	Describes features of application development and integration using Oracle's messaging system, Advanced Queuing. Includes the PL/SQL, C, Visual Basic, Java, and JMS interfaces to AQ and gateways to non-Oracle messaging systems.
Oracle9i Application Developer's Guide - Large Objects (LOBs)	A96591	Describes the following large object (LOB) types and how to use them: Character LOBs (CLOBs) Binary LOBs (BLOBs) External LOBs (BFILEs) Globalization Support LOBs (NCLOBs)
Oracle9i Application Developer's Guide - Object-Relational Features	A96594	Describes how to use user-defined object datatypes to model complex real-world entities, such as customers and purchase orders, as objects in the database.
Oracle9i Application Developer's Guide - Workspace Manager	A96628	Describes how to use Oracle Database Workspace Manager to work with long transactions. Workspace management refers to the ability of the database to hold different versions of the same record (that is, row) in one or more workspaces. Users of the database can then change these versions independently. This manual includes conceptual, usage, and reference information.
Oracle9i Data Cartridge Developer's Guide	A96595	Describes how to implement custom indexing and query optimization services and how to package and use these as a server extension called a data cartridge.
Oracle9i XML Database Developer's Guide - Oracle XML DB	A96620	Describes the following Oracle native XML support features of the Oracle XML database and explains how to use them: XMLType datatype and API to create XMLType columns or tables World Wide Web Consortium (W3C) schema support SQLX function and Oracle SQLX extension functions such as XMLSequence() W3C Xpath support for extraction, condition checks and updates ToObject method for converting an XMLType object to a PL/SQL object type XMLType views W3C XSLT support OCI and JDBC support for XMLType C-Based PL/SQL DOM, Parser and XSLT application program interfaces Oracle XML DB also features a repository, which adds advanced foldering, versioning, and security mechanisms to facilitate using FTP, HTTP, and WebDav to access XML data in the database. This book also discuses JDeveloper and Oracle Enterprise Manager support.
Oracle9i XML Developer's Kits Guide - XDK	A96621	Describes the XML Developer's Kits (XDK) components and how to use them. Contains installation and configuration information and includes documentation of XDK for Java, XDK for C, XDK for C++, and XDK for PL/SQL. (XDK for Java now includes TransXUtility, WebServices (SOAP), and JAX support) Also describes how to build XML based applications using JDeveloper, BC4J/J2EE XML applications and User Interface for XML (UIX) support.
Oracle9i XML Case Studies and Applications	A88895	This manual provides case studies and applications that use Oracle9i's XML-enabled database technology. It describes different ways that XML data can be stored, managed, queried, and exchanged in the database using Oracle XML-enabled technology.
Language and Interface
Oracle Call Interface Programmer's Guide	A96584	Presents the Oracle Call Interface (OCI), an application programming interface (API) that enables applications written in C or C++ to interact with one or more Oracle Databases.
Oracle C++ Call Interface Programmer's Guide	A96583	Presents the Oracle C++ Call Interface (OCCI), an application program interface (API) that enables applications written in C++ to interact with one or more Oracle Databases. Also, to extend the functionality of OTT generated code, programmers may want to add code in the OTT generated file. The way OTT can distinguish between OTT generated code and code added by the user is by looking for some predefined markers (tags). Support for these tags has been added in the Oracle9i release 2 (9.2) database.
PL/SQL User's Guide and Reference	A96624	Presents PL/SQL (Oracle's procedural extension of SQL), an advanced fourth-generation programming language. Explains the concepts behind PL/SQL and illustrates every facet of the language.
ProC/C++ Precompiler Programmer's Guide*	A96108	A comprehensive user's guide and reference to the Oracle Pro*C/C++ precompiler, this manual shows how to develop C++ programs that use the SQL and PL/SQL database languages to access and manipulate Oracle data.
ProC/C++ Precompiler Getting Started for Windows*	A96111	This guide is an addendum to the ProC/C++ Precompiler Programmer's Guide* and contains information specific to the Windows platform
ProCOBOL Precompiler Programmer's Guide*	A96109	A comprehensive user's guide and reference to the Oracle Pro*COBOL Precompiler. It shows how to develop COBOL programs that use the SQL and PL/SQL database languages to access and manipulate Oracle data.
ProCOBOL Precompiler Getting Started for Windows*	A96113	This guide is an addendum to the ProCOBOL Precompiler Programmer's Guide* and contains information specific to the Windows platform
Programmer's Guide to the Oracle Precompilers	A42525	This manual is a comprehensive user's guide and on-the-job reference to the Oracle ProCOBOL and Pro Fortran Precompilers. It show you step-by-step how to develop applications that use the powerful database language SQL to access and manipulate Oracle data.
ProFortran Supplement to the Oracle Precompilers Guide*	A42523	This companion book to the Programmer's Guide to the Oracle Precompilers shows you how to write FORTRAN programs that use the powerful database language SQL to access and manipulate Oracle data.
SQLModule for Ada Programmer's Guide*	A58231	This book is a comprehensive user's guide and reference for SQLModule, an Oracle application development tool. It includes a complete description of Module Language, an ANSI/ISO SQL standard for developing applications that access data stored in a relational database. Module Language uses parameterized procedures to encapsulate SQL statements. The procedures can then be called from an Ada application. This Guide also describes how you can use SQLModule to call PL/SQL procedures stored in an Oracle database. A number of complete examples using Module Language, Ada code, and stored database procedures are provided.
Application Reference
Oracle9i XML API Reference - XDK and Oracle XML DB	A96616	Describes Oracle XML Developer's Kits (XDK) and Oracle XML DB application program interfaces (APIs) for developers building XML applications on the Oracle9i database and provides syntax and a brief description of functions, methods, and procedures associated with them.
Oracle9i Supplied Java Packages Reference	A96609	Presents the Java packages supplied with Oracle8i. Interfaces, classes, and exceptions are summarized in a table. Each is listed in alphabetical order with its syntax, a member summary, and an inherited-member summary. This is followed by details about the fields, constructors, and methods.
Oracle Call Interface Programmer's Guide	A96584	Presents the Oracle Call Interface (OCI), an application programming interface (API) that enables applications written in C or C++ to interact with one or more Oracle Databases.
Oracle C++ Call Interface Programmer's Guide	A96583	Presents the Oracle C++ Call Interface (OCCI), an application program interface (API) that enables applications written in C++ to interact with one or more Oracle Databases.
Oracle9i Supplied PL/SQL Packages and Types Reference	A96612	Describes the PL/SQL packages and defined types supplied with the Oracle Database. Packages are listed alphabetically with syntax, procedures and functions, and parameters described for each package.
**interMedia and Oracle Spatial**
Oracle Spatial User's Guide and Reference	A96630	Provides usage and reference information for indexing and storing spatial data and for developing spatial applications.
Oracle Dynamic Services User's and Administrator's Guide	A88783	Describes Java-based programmatic framework for incorporating, managing, and deploying Internet and intranet services.
Oracle Syndication Server User's and Administrator's Guide	A88787	Describes a comprehensive system for the automated, controlled exchange and management of digital assets among business partners.
Oracle interMedia User's Guide and Reference	A96630	Describes how to enable Oracle9i to store, manage, and retrieve geographic location information, images, audio, video, or other heterogeneous media data in an integrated fashion with other enterprise information.
Oracle interMedia Java Classes User's Guide and Reference	A96121	Describes Java Classes to enable users to write Java applications using interMedia objects.
Oracle interMedia Annotator User's Guide	A96120	Describes how to extract information (or metadata) from media sources of certain formats and insert the metadata along with the media source into an Oracle database.

Oracle Text

Table 4-6 Oracle Text Documentation

Documentation	Part Number	Description
Oracle Text Application Developer's Guide	A96517	Contains information about how to build an application with Oracle Text, such as a text query application or document classification system. Examples are provided for creating a text table, indexing, and querying. This book also contains information about query tuning, document presentation, and using a thesaurus in your application.
Oracle Text Reference	A96518	Contains reference information for Oracle Text, including Oracle Text SQL statements, operators, supplied PL/SQL packages, and views. Examples are provided for using the PL/SQL packages and operators.
Oracle Ultra Search Online Documentation	A97204	Contains information about how to use Oracle Ultra Search to search the contents of a database and the contents of static HTML pages.

4 Oracle9i Documentation