Loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile.
Object Type Identification
- Files with extensions .dat, .ctl, .ldr are included regardless of location
File Extensions
| Name | Description |
|---|---|
.dat .ctl .ldr | SQL*Loader is the utility to use for high performance data loads. The data can be loaded from any text file and inserted into the database. |
...
| Code Block | ||||
|---|---|---|---|---|
| ||||
cp "$SOURCE_FILE" "$XXHR_TOP/bin/"; sqlldr userid=$FDEBS_DB_USER/$FDEBS_DB_PASSWORD control="$XXHR_TOP/bin/sqlloader.ldr" log=loader.log |