EBS Object Types - 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 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