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. |
Attributes
| Name | Description | Default Value | Supported Values |
|---|---|---|---|
| Source | Object Source Location Type | SCM | SCM |
| Target Location | Path to where the file should be deployed. | $<PROD_TOP>/bin/ | |
| Log File | Configuration file used to download/upload data. | loader.log |
Related Project Properties
| Name | Description | Default Value |
|---|---|---|
| EBS SQL LDR Root Source Directory | Source folder for control (ctl) files (e.g. control). | sqlldr |
| EBS SQL LDR Root Destination Directory | Target directory for control (ctl) files (e.g. $XXHR_TOP/admin/bin). | $<PROD_TOP>/admin/bin |
| EBS Data Root Destination Directory | Target directory for Dat files (e.g. $XXHR_TOP/admin/import). | $<PROD_TOP>/patch/115/import |
Sample Build Commands
N/A - Build commands are not supported for this type.
Sample Deploy Commands
cp $SOURCE_FILE $XXHR_TOP/bin/; sqlldr userid=$FDEBS_DB_USER/$FDEBS_DB_PASSWORD control=$XXHR_TOP/bin/sqlloader. log=loader.log