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!
