User`s guide

The Export Utility
2-2 Oracle Database User's Guide
START-PROGRAM $ORAC1120.SQLPLUS
* SCOTT/password
SQL> START $ORAC1120.RDBMS.DEMO.ULCASE1
2. Start SQL*Loader to run the demonstration by entering the following command:
/START-PROGRAM $ORAC1120.SQLLDR
* SCOTT/password $ORAC1120.RDBMS.DEMO.ULCASE1 ULCASE1 ULCASE1
2.2 The Export Utility
The Export utility is used to write data from an Oracle Database into the BS2000
system files. Use this utility with the Import utility to back up your data, and to move
data between Oracle Databases.
For restrictions when using the Export utilities refer to the section, " Known Problems,
Restrictions, and Workarounds" in Oracle Database Installation and Administration Guide
for Fujitsu BS2000/OSD.
2.2.1 Starting the Export Utility
To start the Export utility, EXP , enter the following command:
/START-PROGRAM $ORAC1120.EXP
* SCOTT/password
If you omit the SCOTT/password parameters, then you are prompted for them.
Export dump files are usually created by EXP as SAM files. You can override default
output file specifications by running a file command such as:
/FILE expfile,LINK=explink,FCBTYPE=SAM,RECFORM=F, -
BLKSIZE=(STD,1),RECSIZE=2048
Then, call EXP specifying the following in response to the output file name prompt:
LINK=explink
On a nonkey public volume set you may need to adjust the BLKSIZE and RECSIZE
values for efficient disk-space usage (note that
RECSIZE must be 16 bytes less than the
BLKSIZE on nonkey disks). Specify the RECSIZE value to match the export record size.
For example:
/FILE expfile,LINK=explink,FCBTYPE=SAM,RECFORM=F, -
BLKSIZE=(STD,1),RECSIZE=2032
Note: This example sets up the table for the user SCOTT to run the
demonstrations.
Note: Do not use variable record size with SAM files.
When using a block size ( PAM ) or record size ( SAM ) other than 2048, you
must also specify a corresponding
RECORDLENGTH parameter to EXP on
the options line.