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 7.3.0.0 to 11.2.0.4 [Release 7.3.0 to 11.2]
Oracle Database - Standard Edition - Version 7.3.0.0 to 11.2.0.4 [Release 7.3.0 to 11.2]
Enterprise Manager for Oracle Database - Version 8.1.7.4 to 11.2.0.4
Oracle Database - Personal Edition - Version 7.3.3.0 to 11.2.0.4 [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.

Purpose

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

Scope

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 ?

Details

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
Purpose
Scope
Details
 1. Introduction.
 2. Performance issues.
 3. Restrictions.
 4. Security considerations.
 5. Typical errors.
 6. Known defects.
References

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