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

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1740477955, '3.145.17.171', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/tools/sql-loader/control-file(66): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78