sqlldr
syntax
sqlldr <schema_name>/<schema_password>@<database_name> control=<control_file> log=<log_file> data=<data_file>
example
sqlldr <meschema>/<mepassword>@<medatabase> control=<mecontrol_file> log=<melog_file> data=<medata_file>
<control_file>.ctl control script
LOAD DATA
APPEND INTO TABLE <TABLE_NAME>
FIELDS TERMINATED BY ‘<FIELD_SEPARATOR_VALUE>’ OPTIONALLY ENCLOSED BY ‘<QUOTE_CHARACTER>’
TRAILING NULLCOLS
(<COL1>,
<COL2>,
<COL3>)