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
...
Object Type
Name | Code |
|---|---|
SQL*Loader |
|
Object Type Attributes
Name | Code | 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 | |
Data File |
| Specifies the name of the datafile containing the data to be loaded. | ||
Execute SQL Loader |
| Should SQL Loader be executed | false | |
Target File Permissions |
| Permissions to apply to the file after it is deployed | Defaults to the project property FDEBS_FILE_PERMISSIONS |
...
Name | Code | Description | Default Value |
|---|---|---|---|
SQL*Loader Root Source Directory |
| Source folder for control (ctl) files (e.g. control). | sqlldr |
SQL*Loader Root Destination Directory |
| (Not used currently) | $<PROD_TOP>/admin/bin |
File Permissions |
| Target File Permission. Will be set to target file after deployment using chmod. eg: 755 |
...