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