Export using the direct path method export in Oracle
Up to this point, we have been exporting database information using the conventional path export.
This lesson introduces the use of the direct path export to improve the performance of your database.
The conventional path export uses SQL SELECT statements to extract data from the tables.
Direct path export will read data directly from the database and transfer it to the export file, which avoids the overhead of the SQL statement.
A conventional path is illustrated below.
A direct path should look like the following:
To invoke a direct path, use the parameter direct=y as part of your export command. An example of this is: