What is the direct path Export?

What is the direct path Export?

Rating:

The direct path Export is one of the two methods (the other one is the conventional path Export) that the Export utility provides for exporting table data. The direct path Export is much faster than the conventional path Export because data stored in the buffer cache, which is read from the disk, is directly transferred to the Export client, bypassing the evaluating buffer. Then, the Export client writes the data into the export dump file. The data is already in the format that the Export client expects, avoiding unnecessary data conversion. However, if necessary, the Export client can perform some character set conversions while writing the data into the export dump file.

The direct path Export can be invoked by using the command-line method or an initialization parameter file. The direct path Export cannot be invoked by using the interactive method. Specifying the DIRECT=y on the command line or in the initialization parameter file invokes the direct path Export. Specifying the DIRECT=n, which is the default, invokes the conventional path Export.

The direct path Export supports the export of rows containing object types and LOB data types. However, the actual export is performed by using the conventional path Export, even if the direct path Export is specified.

Rating: