User`s guide

The Import Utility
Oracle Database Utilities 2-3
When exporting a large volume of data, the default disk-space allocation for the
output file will be inappropriate, and the program will spend a significant amount of
time allocating secondary extents of disk space. If the maximum number of extents
exceeds the number that the catalog entry can hold, then an output-file error will
occur.
As a counter-measure, you should always preallocate the EXP output file with the
BS2000 /FILE command, prior to starting the Export utility. When allocating the file,
you should use a realistic estimate for both the primary and secondary space
allocations.
For example:
/FILE LARGE.EXPORT.DMP,LINK=EXPOUT,SPACE=(3000,3000)
/START-PROGRAM $ORAC1120.EXP
* system/manager
...
Export file: EXPDAT.DMP >link=expout
...
2.2.2 Exporting to Foreign Systems
You can export to foreign systems using the following methods:
■ Transferring Data by Tape
■ Transferring Data by File Transfer
2.2.2.1 Transferring Data by Tape
To export directly to tape, enter a FILE command as follows:
/FILE tapefile,LINK=tapelink,FCBTYPE=SAM,RECFORM=F, -
BLKSIZE=2048,RECSIZE=2048,DEV=<device>,VOL=<vsn>
Then, call EXP , specifying the following value in response to the output file name
prompt:
LINK=tapelink
You also must set the EXP_CLIB_FILE_IO environment variable to FALSE in the ORAENV
file.
The export utility writes the output as SAM files, which simplifies export to an Oracle
Database on foreign systems.
2.2.2.2 Transferring Data by File Transfer
If you use FTP, then ensure that you specify binary mode (to avoid automatic
EBCDIC-ASCII conversion).
2.3 The Import Utility
The Import utility is used to write data from the files created by the Export utility to an
Oracle Database.
For restrictions when using the Import utility refer to the section, "Known Problems,
Restrictions and Workarounds" in Oracle Database Installation and Administration Guide
for Fujitsu BS2000/OSD.