My Oracle Support Banner

Parameter DIRECT: Conventional Path Export Versus Direct Path Export (Doc ID 155477.1)

Last updated on APRIL 03, 2020

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 7.3.0 to 11.2]
Oracle Database - Standard Edition - Version to [Release 7.3.0 to 11.2]
Enterprise Manager for Oracle Database - Version to
Oracle Database - Personal Edition - Version to [Release 7.3.3 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Information in this document applies to any platform.


This document provides information about the advantages and known problems, when exporting data from an Oracle database in the Direct Path mode.


The article is intended for users of the Oracle7, Oracle8, Oracle8i, Oracle9i, and Oracle10g databases who wish to use the EXPORT utility to export data from an Oracle database in a Direct Path mode, rather than the usual Conventional Path mode. The article gives information about the difference between both modes, the advantages of a Direct Path export, but also the restrictions, some security considerations, the typical error messages, and some Direct Path related bugs with possible workarounds.
This document is only applicable to the original Export client (exp). From Oracle10g, we recommend to use the new Export Data Pump (expdp) and Import Data Pump (impdp) clients. For Data Pump specific details, see also:
<Note 552424.1> - Export/Import DataPump Parameter ACCESS_METHOD - How to enforce a method of loading and unloading data ?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Introduction.
 2. Performance issues.
 3. Restrictions.
 4. Security considerations.
 5. Typical errors.
 6. Known defects.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.