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. ...