Ask the Expert

DIRECT=Y versus DIRECT=N when importing

What is the functional difference between:
  1. importing a direct export dump (i.e. direct=y while exporting) and
  2. importing a conventional export dump (i.e. direct=n while exporting)

    Requires Free Membership to View

  1. There is no difference. The choice you make on export effects how the export extracts data to the dump file... it does not have anything to do with importing.

    When you use DIRECT=Y this causes export to extract data by reading the data directly, bypassing the SQL Command Processing layer. This method can be much faster than a conventional path export.

    Conventional 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.

    In a direct path export, data is read from disk into the buffer cache and rows are transferred directly to the export client. The evaluating buffer 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.

    For More Information

    This was first published in March 2003

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: