Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from 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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page