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

Export-Only Parameters

The following parameters can only be used with the Export utility:

COMPRESS = Y | N

Specifies how Export manages the initial extent for table data. The default, COMPRESS=Y, causes export to write a CREATE object statement for use in a subsequent import that will cause the object to be created with all the exported data in a single initial extent. If you specify COMPRESS=N, Export uses the current storage parameters, including the values of the INITIAL extent size and the NEXT extent size.

CONSISTENT = Y | N

Specifies whether Export uses the SET TRANSACTION READ ONLY statement to ensure that the data seen by Export is consistent to a single point in time and does not change during the execution of the exp command. You should specify CONSISTENT=Y when you anticipate that other applications will update the database after an export has started. The default is CONSISTENT=N.

DIRECT = Y | N

Specifies direct path or conventional path export. Direct path exports extract data by reading the data directly, bypassing the SQL processing layer, which can be much faster than a conventional path export. The default is DIRECT=N. Direct path export cannot be used to export tables containing any of the following column types: REF, LOB, BFILE, or object type columns, which include VARRAYs and nested tables.

FLASHBACK_SCN = n

Indicates the System Change Number used for flashback on the export. New with Oracle9i.

FLASHBACK_SCN = time

Indicates the time used for flashback on the export. ...

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