Oracle8i Utilities
Release 8.1.5






Prev Next


This manual describes how to use the Oracle8i utilities for data transfer, maintenance, and database administration.

Oracle8i Utilities contains information that describes the features and functionality of the Oracle8i and the Oracle8i Enterprise Edition products. Oracle8i and Oracle8i Enterprise Edition have the same basic features. However, several advanced features are available only with the Enterprise Edition, and some of these are optional.

For information about the differences between Oracle8i and the Oracle8i Enterprise Edition and the features and options that are available to you, see Getting to Know Oracle8i.

The Oracle Utilities

This manual describes the basic concepts behind each utility and provides examples to show how the utilities are used.


This manual is for database administrators (DBAs), application programmers, security administrators, system operators, and other Oracle users who perform the following tasks:

To use this manual, you need a working knowledge of SQL and Oracle fundamentals, information that is contained in Oracle8i Concepts. In addition, SQL*Loader requires that you know how to use your operating system's file management facilities.

Note: This manual does not contain instructions for installing the utilities, which is operating system-specific. Installation instructions for the utilities can be found in your operating system-specific Oracle documentation.

How Oracle8i Utilities Is Organized

This manual is divided into three parts:

Part I: Export/Import

Chapter 1, "Export"

This chapter describes how to use Export to write data from an Oracle database into transportable files. It discusses export guidelines, export modes, interactive and command-line methods, parameter specifications, and describes Export object support. It also provides example Export sessions.

Chapter 2, "Import"

This chapter describes how to use Import to read data from Export files into an Oracle database. It discusses import guidelines, interactive and command-line methods, parameter specifications, and describes Import object support. It also provides several examples of Import sessions.

Part II: SQL*Loader

Chapter 3, "SQL*Loader Concepts"

This chapter introduces SQL*Loader and describes its features. It also introduces data loading concepts (including object support). It discusses input to SQL*Loader, database preparation, and output from SQL*Loader.

Chapter 4, "SQL*Loader Case Studies"

This chapter presents case studies that illustrate some of the features of SQL*Loader. It demonstrates the loading of variable-length data, fixed-format records, a free-format file, multiple physical records as one logical record, multiple tables, direct path loads, and loading objects, collections, and REF columns.

Chapter 5, "SQL*Loader Control File Reference"

This chapter describes the control file syntax you use to configure SQL*Loader and to describe to SQL*Loader how to map your data to Oracle format. It provides detailed syntax diagrams and information about specifying data files, tables and columns, the location of data, the type and format of data to be loaded, and more.

Chapter 6, "SQL*Loader Command-Line Reference"

This chapter describes the command-line syntax used by SQL*Loader. It discusses command-line arguments, suppressing SQL*Loader messages, and sizing the bind array, and more.

Chapter 7, "SQL*Loader: Log File Reference"

This chapter describes the information contained in SQL*Loader log file output.

Chapter 8, "SQL*Loader: Conventional and Direct Path Loads"

This chapter describes the differences between a conventional path load and a direct path load -- a high performance option that significantly reduces the time required to load large quantities of data.

Part III: Offline Database Verification Utility

Chapter 9, "Offline Database Verification Utility"

This chapter describes how to use the offline database verification utility, DBVERIVY.

Appendix A, "SQL*Loader Reserved Words"

This appendix lists the words reserved for use only by SQL*Loader.

Appendix B, "DB2/DXT User Notes"

This appendix describes differences between the data definition language syntax of SQL*Loader and DB2 Load Utility control files. It discusses SQL*Loader extensions to the DB2 Load Utility, the DB2 RESUME option, options (included for compatibility), and SQL*Loader restrictions.

Conventions Used in This Manual

This manual follows textual and typographic conventions explained in the following sections.

Text of the Manual

The following conventions are used in the text of this manual:


Uppercase text is used to call attention to command keywords, object names, parameters, filenames, and so on, for example:  


"If you create a private rollback segment, its name must be included in the ROLLBACK_SEGMENTS parameter in the PARAMETER file."  

Italicized Words  

Italicized words are used at the first occurrence and definition of a term, as in the following example:  


"A database is a collection of data to be treated as a unit. The general purpose of a database is to store and retrieve related information, as needed."  


Italicized words are used also to indicate emphasis, book titles, and to highlight names of performance statistics.  

PL/SQL, SQL, and SQL*Plus commands and statements are displayed in a fixed-width font using the following conventions, separated from normal text as in the following example:


Punctuation: , ' "  

Example statements may include punctuation such as commas or quotation marks. All punctuation given in example statements is required. All statement examples end with a semicolon. Depending on the application in use, a semicolon or other terminator may or may not be required to end a statement.  


Uppercase words in example statements indicate the keywords in Oracle SQL. However, when you issue statements, keywords are not case-sensitive.  

Lowercase Words: emp, users2.ora  

Lowercase words in example statements indicate words supplied only for the context of the example. For example, lowercase words may indicate the name of a table, column, or file. Some operating systems are case sensitive, so refer to your installation or user's manual to find whether you must pay attention to case.  

We Welcome Your Comments

We value and appreciate your comments as an Oracle user and reader of our manuals. As we write, revise, and evaluate, your opinions are the most important input we receive. At the back of this manual is a Reader's Comment Form that we encourage you to use to tell us both what you like and what you dislike about this (or other) Oracle manuals. If the form is missing, or you would like to contact us, please use the following address or fax number:

Oracle8i Documentation Manager
Oracle Corporation
500 Oracle Parkway
Redwood City, CA 94065
FAX: 650.506.7228 Attn.: Oracle8i Utilities

You can also e-mail your comments to the Information Development department:


Copyright © 1999 Oracle Corporation.

All Rights Reserved.