Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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.

File Extensions 
NameDescription
.sqlldrSQL*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.


Attributes
NameDescriptionDefault ValueSupported Values
SourceObject Source Location Type

SCM

SCM
Target LocationPath to where the file should be deployed to.$<PROD_TOP>/bin/
Log FileConfiguration file used to download/upload data.loader.log


Related Project Properties
NameDescriptionDefault Value
EBS SQL LDR Root Source DirectorySource folder for control (ctl) files (e.g. control).sqlldr
EBS SQL LDR Root Destination DirectoryTarget directory for control (ctl) files (e.g. $XXHR_TOP/admin/bin).$<PROD_TOP>/admin/bin
EBS Data Root Destination DirectoryTarget directory for Dat files (e.g. $XXHR_TOP/admin/import).$<PROD_TOP>/patch/115/import


Sample Build Commands 

N/A - Build commands 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. log=loader.log


Considerations

None

  • No labels