CONTROL

Default: There is no default.

Purpose

The CONTROL parameter specifies the name of the SQL*Loader control file that describes how to load the data.

Syntax and Description

CONTROL=control_file_name

If a file extension or file type is not specified, then it defaults to .ctl. If the CONTROL parameter is not specified, then SQL*Loader prompts you for it.

If the name of your SQL*Loader control file contains special characters, then your operating system may require that they be preceded by an escape character. Also, if your operating system uses backslashes in its file system paths, then you may need to use multiple escape characters or to enclose the path in quotation marks. See your Oracle operating system-specific documentation for more information.

See Also:

SQL*Loader Control File Reference for a detailed description of the SQL*Loader control file

Example

The following example specifies a control file named emp1. It is automatically given the default extension of .ctl.

CONTROL=emp1