Oracle in a Nutshell

Command-Line Parameters

Command-line parameters are separated by commas, spaces, or both. All filename parameters can either use a specific filename or include a path.

BAD = path_filename

Specifies the name of the bad file. By default, the bad file takes the name of the control file, but with a .bad extension, and is written to the same directory as the control file. If you specify a different name, the default extension is still .bad. However, if you use the BAD parameter to specify a bad-file name, the default directory becomes your current working directory. If you are loading data from multiple files, then this bad-file name gets associated only with the first file being loaded.

BINDSIZE = bytes_in_bind_array

Specifies the maximum size, in bytes, of the bind array. This parameter overrides any bind array size computed as a result of using the ROWS parameter. The default bind array size is 65,536 bytes, or 64K.

COLUMNARRAYROWS = integer

Specifies the number of rows to allocate for direct path column arrays. New with Oracle9i.

CONTROL = control_filename

Specifies the name, which may include the path, of the control file. The default extension is .ctl. If a control file is not specified, you will be prompted for one.

DATA = path_filename

Specifies the name of the file containing the data to load. By default, the name of the control file is used, but with the .dat extension. If you specify a different name, the default extension is still .dat. If you are loading from multiple ...