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.
By using direct path, you:
Can improve the performance of a database direct read mode by setting the
appropriate database version number, where the version number is 7.1.5 or higher.
May increase the value of the
usually to a multiple of
DB_BLOCK_SIZE or a
multiple of the file system I/O block size.
Cannot export rows containing LOB, BFILE, REF, or object type columns. Only the data definition to create the table is
Must match the database character set with the client character set. Therefore, you must use the database character
Cannot use an interactive session with direct path export.
The following SlideShow provides sample output from a full direct path export:
Direct Path Export
In the next lesson, you will learn how to use Import to restore your database objects.