Parameter DIRECT: Conventional Path Export Versus Direct Path Export
(Doc ID 155477.1)
Last updated on APRIL 03, 2020
Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 7.3.0 to 11.2] Oracle Database - Standard Edition - Version 22.214.171.124 to 126.96.36.199 [Release 7.3.0 to 11.2] Enterprise Manager for Oracle Database - Version 188.8.131.52 to 184.108.40.206 Oracle Database - Personal Edition - Version 220.127.116.11 to 18.104.22.168 [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!