SQL*Loader 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 data 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 |
Object Type Attributes
| Name | Code | Description | Default Value | Supported Values |
|---|---|---|---|---|
| Source | SOURCE | Object Source Location Type | SCM | SCM |
| Target Location | TARGET_LOCATION | Path to where the file should be deployed. | $<PROD_TOP>/bin/ | |
| Log File | LOG_FILE | Configuration file used to download/upload data. | loader.log | |
| Data File | DATA_FILE | Specifies the name of the datafile containing the data to be loaded. | ||
| Execute SQL Loader | EXECUTE_LDR | Should SQL Loader be executed | false | |
| Target File Permissions | FILE_PERMISSIONS | Permissions to apply to the file after it is deployed | Defaults to the project property FDEBS_FILE_PERMISSIONS |
Related Project Properties
| 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 |
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.ldr" log=loader.log