Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Common Parameters

The following identifier is used for many different Export and Import commands:

filename

Name for an export file or log file. The default filename for an export file is expdat.dmp. The default extension is .dmp for an export file and .log for a log file.

The following parameters can also be used with both the Export and Import utilities:

BUFFER = buffersize

Specifies the size, in bytes, of the buffer used to fetch or load rows. This parameter determines the maximum number of rows in an array fetched by the Export utility as:

rows = buffer / maximum_row_size

If you specify 0, Export fetches one row at a time, or Import loads one row at a time. Tables with LONG, LOB, BFILE, REF, ROWID, or type columns are always fetched or loaded one row at a time. BUFFER applies only to conventional path export and has no effect on a direct path export. The default is operating system dependent.

CONSTRAINTS = Y | N

Specifies whether table constraints are exported or imported. The default is Y.

FEEDBACK = n

When set greater than 0, specifies that Export or Import should display a progress meter in the form of a dot for each n number of rows exported. The default is 0.

FILE = filename

Specifies the name of the export file or the file created by the Export utility that is the source of the import. This parameter can take multiple filenames if the size of the file is limited by the FILESIZE parameter, as of Oracle8i. filename is a common identifier, defined earlier.

FILESIZE = n

Limits ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page