User`s guide

2
Oracle Database Utilities 2-1
2 Oracle Database Utilities
This chapter describes how you start the following Oracle Database utilities:
■ SQL*Loader
■ The Export Utility
■ The Import Utility
■ The Data Pump Export Utility
■ The Data Pump Import Utility
■ Oracle Text Loader
For a more detailed discussion of these utilities, refer to Oracle Database Utilities.
2.1 SQL*Loader
SQL*Loader is a tool used for moving data from an external file (or files) into the
tables of an Oracle database. SQL*Loader can load data in several formats and can
even load several tables simultaneously. You can also use it to load only records that
match a particular data value. Refer to the Oracle Database Utilities manual for a
detailed description of SQL*Loader and its demonstration files.
For restrictions when using SQL*Loader refer to the section, " Known Problems,
Restrictions, and Workarounds" in Oracle Database Installation and Administration Guide
for Fujitsu BS2000/OSD.
2.1.1 Starting the SQL*Loader Utility
To start SQL*Loader, enter the following command:
/START-PROGRAM $ORAC1120.SQLLDR
* SCOTT/password
2.1.2 Using the SQL*Loader Demonstration Files
The demonstration files are shipped under:
$ORAC1120.RDBMS.DEMO.ULCASE*.CTL
$ORAC1120.RDBMS.DEMO.ULCASE*.SQL
$ORAC1120.RDBMS.DEMO.ULCASE*.DAT
To run the ULCASE1 demo use the following steps:
1. Run SQL*Plus and set up the table to be used in the demonstration by entering the
following commands: