Siemens BS2000/OSD Guía de usuario descargar pdf (Pagina 21)

Oracle Database Utilities 2-1

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:

1 2 ... 16 17 18 19 20 21 22 23 24 25 26 ... 79 80

Sin comentarios

Siemens BS2000/OSD Guía de usuario Pagina 21