Versions Compared

Old Version 10

changes.mady.by.user Karl Henselin

Saved on

compared with

New Version Current

changes.mady.by.user Tristan Butzine (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Loads 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 datafile. The project object will be passed in as the control 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

EBS

SQL

LDR

*Loader Root Source Directory

FDEBS_SQL_LDR_ROOT_SOURCE_DIR

Source folder for control (ctl) files (e.g. control).

sqlldr

EBS

SQL

LDR Root

*Loader Root Destination Directory

FDEBS_SQL_LDR_ROOT_DESTINATION_DIR

Target directory for control (ctl) files (e.g. $XXHR_TOP/admin/bin).

(Only used for full deploy projects

(Not used currently)

$<PROD_TOP>/admin/bin

EBS Data Root Destination DirectoryFDEBS_DAT_ROOT_DESTINATION_DIR

Target directory for Dat files (e.g. $XXHR_TOP/admin/import).

(Only used for full deploy projects)

$<PROD_TOP>/patch/115/import

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
languagebashthemeRDark
cp "$SOURCE_FILE" "$XXHR_TOP/bin/";
sqlldr  userid=$FDEBS_DB_USER/$FDEBS_DB_PASSWORD control="$XXHR_TOP/bin/sqlloader.ldr" log=loader.log