This guide describes installation, maintenance, and use of the Oracle Database 11g Release 2 (11.2).

General information about the Oracle Database for all operating systems is available in the Oracle Database documentation set.

This preface contains the following topics:


This guide is intended for users of the Oracle Database using the BS2000/OSD operating system and for those who provide support to these users. Users installing the Oracle Database, or administering the Oracle Database, or both, see the Oracle Database Installation and Administration Guide for Fujitsu BS2000/OSD for more information.

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at

Access to Oracle Support

Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit or visit if you are hearing impaired.

Using Oracle Database Documentation

The Oracle Database products using BS2000/OSD operating system are identical in the way in which they are supported. However, because of the diversity of operating systems, the use of applications may differ slightly between different operating systems. As a result, Oracle provides two types of documentation:

Type Meaning/Usage
Generic This is the primary Oracle Database documentation, which describes how the product works and how it is used. Use this type of documentation to learn about product functions and how to use any Oracle Database product or utility.
System Specific This documentation provides the information required to use the product under a specific operating system. Use this type of documentation to determine whether there are any system-specific deviations from the generic documentation.

This manual is written for users of Oracle Database 11g Release 2 (11.2) for BS2000/OSD, providing them with BS2000/OSD-specific information about using Oracle Database products. It does not describe how to use a product unless its use is different than that described in the generic documentation.

System programmers and database administrators responsible for installing the Oracle Database, or administering the Oracle Database, or both, should read this manual and the Oracle Database Installation and Administration Guide for Fujitsu BS2000/OSD. There are places where the information in these manuals overlap and is presented differently depending on the target audience.

The reader is assumed to have a fundamental knowledge of BS2000/OSD. No attempt is made to document features of BS2000/OSD except as they affect or are affected by the Oracle Database 11g Release 2 (11.2).

Related Documents

For more information, see the following resources:

Printed documentation is available for sale in the Oracle Store at

To download free release notes, installation documentation, white papers, or other collateral, visit the Oracle Technology Network (OTN). You must register online before using OTN; registration is free and can be done at

If you already have a user name and password for OTN, then you can go directly to the documentation section of the OTN website at

Conventions Used in this Manual

The following conventions are observed in this manual.

Typographic Conventions

The following text conventions are used in this manual:

Convention Meaning
boldface Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.
italic Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.
monospace Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.

Command Syntax

Item Syntax
Commands This font identifies text which must be entered exactly as shown:
set echo off
Variables Variables appear in italics. Substitute an appropriate value, for example:


Required Items Required items are enclosed in braces { }. You must choose one of the alternatives.
DEFINE { macro1 | macro2 }
Optional Items Optional items are enclosed in square brackets [].

[options] formname [userid/password]

Repetitive Items An ellipsis, ... represents an arbitrary number of similar items.

CHKVAL fieldname value1 value2... valueN


The following symbols should always be entered as they appear in the command format:

Name Symbol
ampersand &
backslash \
colon :
comma ,
double quotation mark "
equal sign =
hyphen -
number sign #
parantheses ()
period .
semicolon ;
single quotation mark '