User`s guide

ManualsBrandsSiemens ManualsComputer equipmentBS2000/OSD

The Data Pump Export Utility

2-4 Oracle Database User's Guide

2.3.1 Starting the Import Utility

To start the Import utility, IMP, enter the following command:

/START-PROGRAM $ORAC1120.IMP

* SCOTT/password [options]

If you omit the

SCOTT/password

parameters, then you are prompted for them.

2.3.2 Importing from Foreign Systems

This section gives you some guidelines on importing data from non-BS2000 systems.

2.3.2.1 Import File Block Size

If the import file on the BS2000/OSD operating system has a block size (

BLKSIZE

) not

equal to 2 KB, then you must specify the block size during import with the Import

parameter

RECORDLENGTH

2.3.2.2 Transferring Data by Tape

The Import utility can read directly from tape, provided the file can be processed as a

SAM

file, which is usually the case even for

EXP

files created on foreign systems (for

example, as a sequence of fixed 2 KB blocks).

To read a foreign export file directly, enter a

FILE

command such as the following:

/FILE tapefile,LINK=tapelink,DEV=T-C1,STATE=FOREIGN

Then, call

IMP

, specifying the following as the input file name at the input file name

prompt:

LINK=tapelink

You must also set the

IMP_CLIB_FILE_IO

environment variable to

FALSE

in the

ORAENV

file.

2.3.2.3 Transferring Data by File Transfer

If you use FTP, then ensure that you specify binary mode (to avoid automatic

ASCII-EBCDIC conversion). The received file will be stored as a

PAM

file by the BS2000

FTP utility and can immediately be used as an input file to

IMP

When you try to use an export file from BS2000 as an import file on an ASCII platform

use as transfer utility FTP on BS2000 side and indicate the parameters binary and ftyp

binary in order to avoid insertion of NL (new lines) at block boundaries.

2.4 The Data Pump Export Utility

Data Pump Export and Import are functionally similar to Export and Import discussed

previously, but all of the I/O processing for dump files is done in the Oracle Database

server rather than in the client utility session.

The Data Pump Export utility is used to write data from an Oracle Database into the

BS2000 system files. Use this utility with the Data Pump Import utility to backup your