SQLLDR is a basic
tool to load data from a text file
into an Oracle database table. The control file
(filename.ctl) maps the file data to the Oracle table
structure and some basic transformations (Oracle functions
or custom functions) can be called during load, which can
have some impact on the load performance
(TO_DATE(:last_sold_date, 'YYYYMMDD') in example below).
For direct loads, there cannot be any transformations.
The example shown below is to execute SQLLDR in Microsoft
Windows environment. The same can be setup as a UNIX/Linux
shell script with necessary OS settings (ORACLE_HOME,
bin directory etc.). The data file in this example is in
On execution of the batch file, the user will be
prompted for password. When executed in an
automated load setup, the password will be passed
by a parameter file. The files will be uploaded
to designated directories, setup as
Oracle registered trademark of Oracle Corporation.