Oracle EBS (ERP): SQL Loader Shell Script example

SQL Loader Shell Script example

#SQL Loader Shell Script

Open Linux (Putty)-> login application user - > run below command

sqlldr control=$XXJG_TOP/bin/XXJG_ITEM_MASTER_UPLOAD.ctl userid=apps/appl@uatv2 data=$JXXG_TOP/bin/JG_ITEM_MASTER_DATA.csv log=$XXJG_TOP/bin/JG_ITEM_MASTER_DATA.log errors=10000

After run command successfully JG_ITEM_MASTER_DATA.csv data upload in Oracle database table.

SQL*Loader Control File Reference