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. The project object will be passed in as the control file.
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. |
Object Type
| Name | Code |
|---|---|
| SQL*Loader | SQL_LDR |
...
| Name | Code | Description | Default Value |
|---|---|---|---|
| SQL*Loader Root Source Directory | FDEBS_SQL_LDR_ROOT_SOURCE_DIR | Source folder for control (ctl) files (e.g. control). | sqlldr |
| SQL*Loader Root Destination Directory | FDEBS_SQL_LDR_ROOT_DESTINATION_DIR | (Not used currently) | $<PROD_TOP>/admin/bin |
| File Permissions | FDEBS_FILE_PERMISSIONS | Target File Permission. Will be set to target file after deployment using chmod. eg: 755 |
...