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
| 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 |
...