Oracle A423961 Manual Do Utilizador

3 – 22

Oracle7 Server Getting Started for Windows NT 

C:\> EXP73 [options]

Import

Use the Import utility to import database tables and other objects that
you exported using the Export utility. To start Import, type:

C:\> IMP73 [options]

See Oracle7 Server Utilities for complete usage instructions and
command–line options available for Export and Import.

BUFFER and RECORDLENGTH Defaults

When running the Export and Import utilities from the Oracle7 Server
for Windows NT, note that the default values for certain parameters are
operating–system specific. Specifically, the BUFFER parameter defaults
to a value of 4K under Windows NT and the RECORDLENGTH
parameter defaults to 2K.

SQL*Loader enables you to load data from delimited ASCII text files
and fixed–length record files.

SQL*Loader Release 7.3 includes a direct path option that bypasses the
Oracle redo log and data verification features, thereby decreasing
loading time. Use the direct path option only with data files known to be
error free. To start SQL*Loader, type:

C:\> SQLLDR73 [options]

Windows NT supports the following processing options:

•

“VAR”—load variable length records. Specify the OSD ”VAR
<recsizehint>” in the control file for this option to take effect. The
maximum size is 64K bytes.

•

“FIXn”—fixed record format in which each record is exactly n
bytes long. If the record is terminated by a newline character, the
newline character must be the nth byte.

•

“”—stream record format in which each record is terminated by a
newline character. The maximum record size is 48K bytes.

   For a complete list of options and

instructions on using SQL*Loader, see the Oracle7 Server