Search notes:

Oracle SQL*Loader: Control File

A control file is used by SQL*Loader to store the values of options.
--
--   A comment is prepended by two hyphens
--
options (
--
-- The options clause is optional. It allows
-- to specifiy options that can also be given
-- on the command line.
--
   direct   = true,
   errors   = 0,
   parallel = false
)
unrecoverable   -- can only be used with direct path loads
load data
badfile        "sh_t-happens.bad"
discardfile    "gone-with-the-wind.dsc"
infile         "some-data.dat"
into table      THE_DEST_TABLE
insert      --  or 'append', or 'truncate' (See SQL*Loader: FOR INSERT option, table must be empty.  Error on table …)
when < conditions >
(
  field_one …
  field_two …
)

See also

SQL*Loader
The control file that is needed by SQL*Loader is not the same thing as the control file that is used for the Oracle database.

Index