Keywords
- filename
Name of the file containing the data to be loaded.
- *
Indicates that the data is included in the control file.
- BADFILE
Specifies the location of the bad file, which is created if errors result from bad data in the object file(s).
- DISCARDFILE
Specifies the location of the discard file, which holds any rows discarded during operation.
- DISCARDS, DISCARDMAX
Specifies the maximum number of records to discard before terminating the load.
- FIELDS TERMINATED BY
Include before any of the fields in a FIELDS clause to specify a standard terminator for all fields. The global termination can be overridden in the individual field definitions or in an operating system-specific “str” clause for the INFILE. For more details on termination, see the description of the Datatype clause.
- os_specific_options
See the Oracle documentation for your specific platform.