DIRECT

Default: FALSE

Purpose

The DIRECT parameter specifies the load method to use, either conventional path or direct path.

Syntax and Description

DIRECT=[TRUE|FALSE]

A value of TRUE specifies a direct path load. A value of FALSE specifies a conventional path load.

This parameter overrides the default load method of external tables, used by SQL*Loader express mode.

For some errors, SQL*Loader express mode automatically switches from the default external tables load method to direct path load. An example of when this might occur would be if a privilege violation caused the CREATE DIRECTORY SQL command to fail.

If you use the DIRECT parameter to specify a conventional or direct path load, then the following regular SQL*Loader parameters are valid to use in express mode:

• BINDSIZE

• COLUMNARRAYROWS (direct path loads only)

• DATE_CACHE

• ERRORS

• MULTITHREADING (direct path loads only)

• NO_INDEX_ERRORS (direct path loads only)

• RESUMABLE

• RESUMABLE_NAME

• RESUMABLE_TIMEOUT

• ROWS

• SKIP

• STREAMSIZE

Restrictions

• None

Example

In the following example, SQL*Loader uses the direct path load method for the load instead of external tables:

> sqlldr hr TABLE=employees DIRECT=TRUE