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 …
)