Export provides two methods for exporting table data:
Conventional path Export
- Conventional path Export
- Direct path Export
uses the SQL SELECT statement to extract data from tables.
Data is read from disk into a buffer cache, and rows are transferred to the evaluating buffer.
The data, after passing expression evaluation, is transferred to the Export client, which then writes the data into the export file.
Direct path Export
is much faster than conventional path Export because data is read from disk into the buffer cache and rows are transferred directly to the Export client.
The evaluating buffer (that is, the SQL command-processing layer) is bypassed. The data is already in the format that Export expects, thus avoiding unnecessary data conversion. The data is transferred to the Export client, which then writes the data into the export file.